RE: Theory question regarding tables sql, foriegn keys

2002-01-22 Thread Roger Baklund
* Investor Do you only query Table C or do you structure the query to get info from all three tables? You structure the query to get info from all three tables. URL: http://www.mysql.com/doc/S/E/SELECT.html -- Roger -

Theory question regarding tables sql, foriegn keys

2002-01-20 Thread Investor
So far I have successful set up tables in mysql InnoDB with primary and foriegn keys. Unfortunately I am having some difficulty in getting the proper results as I am new to sql and databases. I would be most grateful if someone took a minute and explained or helped with the following :