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!

"Troy" <corptkm (AT) yahoo (DOT) com> wrote

select a,b,c from table where c<100

inner, full outer, left outer, right outer, cross

yes. yes.

distinct works on a column

can be - or an inner join. or a left join.

slap him. or tell him he can live with you rather than paying someone
else a bucket of money to answer his stupid questions...

hope we have - expect someone will do it better than me too... :P

"Troy" <corptkm (AT) yahoo (DOT) com> wrote

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 (AT) yahoo (DOT) com> wrote