By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

Need answer to SQL question

P: n/a
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!
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Troy" <co*****@yahoo.com> wrote in message news:<uf********************@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
Jul 20 '05 #2

P: n/a
"Troy" <co*****@yahoo.com> wrote in message news:<uf********************@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
Jul 20 '05 #3

P: n/a
Bas
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" <co*****@yahoo.com> wrote in message
news:uf********************@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!

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.