eZabel

Forum / SQL View full thread →

theremin Mar 19, 2004

I did all the ones I could, but had trouble coming up with like the last 6 of the SQL statements required. So, I put what the database looks like, and the problems I couldn't figure out into Word....

iwz Mar 19, 2004

Ok, well for #2 on that page.. you basically want to join the REP and CUSTOMER tables on the REP_NUM column, and also CUSTOMER.CREDIT_LIMIT = '$10,000.00'. Then just add in the DISTINCT keyword ...

deanh77 Mar 22, 2004

or you could do an inner join.

iwz

Mar 22, 2004

how would you write that?

deanh77Founder

Mar 22, 2004

well.. a select with a WHERE clause that matches two columns from different tables IS an INNER JOIN (by definition).

you can use the following syntax if you like.

SELECT DISTINCT(REP_NUM, LAST_NAME, FIRST_NAME)
FROM REP INNER JOIN CUSTOMER
ON REP.REP_NUM = CUSTOMER.REP_NUM
WHERE CUSTOMER.CREDIT_LIMIT = '$10,000'

hehehe... just being difficult.

thereminOG 2002

Mar 23, 2004

Good to know. Thanks. I haven't tried INNER JOINs yet, because I didn't understand them, but now I do, a little better.

deanh77Founder

Mar 24, 2004

in case I wasn't clear enough:

SELECT col1, col2 FROM table1, table2 WHERE table1.col3 = table2.col9

is an inner join.

← View full thread

Welcome Back to eZabel

eZabel Lore

Everything Preserved

Gems