me to a place that would have the answers to the following 5 questions.
1. I need an example of SQL select statement. (table tblSource, fields A,B,C
where C<100).. "is this an example that I have in ( )?
2. I need to list 3 table joins or is "inner, outer, left" etc actual table
joins? what are the others for my own knowledge.
3. Can you join a table to itself? (how? Alias.)
4. What is the diff, between distince and distinct row?
5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
answer?
I am very sorry for my stupidy but I am trying to learn and my boss for one
reason or another gave me a ton of questions I cant answer.
Someone please help!"Troy" <corptkm@.yahoo.com> wrote in message news:<ufCXa.3722$Jk5.3134633@.feed2.centurytel.net>...
> I would really appreciate it if someone could give me the answers or direct
> me to a place that would have the answers to the following 5 questions.
> 1. I need an example of SQL select statement. (table tblSource, fields A,B,C
> where C<100).. "is this an example that I have in ( )?
select a,b,c from table where c<100
> 2. I need to list 3 table joins or is "inner, outer, left" etc actual table
> joins? what are the others for my own knowledge.
inner, full outer, left outer, right outer, cross
> 3. Can you join a table to itself? (how? Alias.)
yes. yes.
> 4. What is the diff, between distince and distinct row?
distinct works on a column
> 5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
> answer?
can be - or an inner join. or a left join.
> I am very sorry for my stupidy but I am trying to learn and my boss for one
> reason or another gave me a ton of questions I cant answer.
slap him. or tell him he can live with you rather than paying someone
else a bucket of money to answer his stupid questions...
> Someone please help!
hope we have - expect someone will do it better than me too... :P|||"Troy" <corptkm@.yahoo.com> wrote in message news:<ufCXa.3722$Jk5.3134633@.feed2.centurytel.net>...
> I would really appreciate it if someone could give me the answers or direct
> me to a place that would have the answers to the following 5 questions.
> 1. I need an example of SQL select statement. (table tblSource, fields A,B,C
> where C<100).. "is this an example that I have in ( )?
> 2. I need to list 3 table joins or is "inner, outer, left" etc actual table
> joins? what are the others for my own knowledge.
> 3. Can you join a table to itself? (how? Alias.)
> 4. What is the diff, between distince and distinct row?
> 5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
> answer?
> I am very sorry for my stupidy but I am trying to learn and my boss for one
> reason or another gave me a ton of questions I cant answer.
> Someone please help!
At the risk of appearing cynical, your questions look very like an
academic work assignment, and not much like a series of questions from
your "boss".
I suggest you search Google for "sql tutorial" or something similar,
and you should be able to find some useful discussions of basic SELECT
syntax etc. Or any SQL book will cover the same material. None of your
questions are difficult, so it shouldn't be too much effort to work
them out.
Simon|||Hey, you're not trying to have us do your school homework for you, do you?
Those questions look like a school assignment to me..
;P
Bas
"Troy" <corptkm@.yahoo.com> wrote in message
news:ufCXa.3722$Jk5.3134633@.feed2.centurytel.net.. .
> I would really appreciate it if someone could give me the answers or
direct
> me to a place that would have the answers to the following 5 questions.
> 1. I need an example of SQL select statement. (table tblSource, fields
A,B,C
> where C<100).. "is this an example that I have in ( )?
> 2. I need to list 3 table joins or is "inner, outer, left" etc actual
table
> joins? what are the others for my own knowledge.
> 3. Can you join a table to itself? (how? Alias.)
> 4. What is the diff, between distince and distinct row?
> 5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
> answer?
> I am very sorry for my stupidy but I am trying to learn and my boss for
one
> reason or another gave me a ton of questions I cant answer.
> Someone please help!
