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....

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 ...

or you could do an inner join.

how would you write that?

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, LAS...

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