anybody know how to use microsoft access?



3 tables: Customer, Supplier, City

How do I go about selecting suppliers that aren't from California... but under the Supplier table... it does not list the state, it only list cityID which is linked to the City table where the state is listed.
 
SELECT * FROM SUPPLIER JOIN CITY ON SUPPLIER.CITY = CITY.CITY WHERE CITY.STATE <> CA

Oh wait, did you say Access? Don't you just draw lines to each object or something .... like Crystal Reports?
 
You must log in or register to reply here.
Top Bottom