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. http://www.mysql.com/doc/S/E/SELECT.html > -- Roger - Be

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 follow

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