Re: Newbie question on multiple tables

2004-10-30 Thread Gleb Paharenko
Hi. You may read: http://dev.mysql.com/doc/mysql/en/JOIN.html http://dev.mysql.com/doc/mysql/en/SELECT.html There is a good description. Searching in more than two tables (3 in my example) may be done in such way: select t1.* from t1,t2,t3 where t1.a=t2.a and t1.b=t3.b But using

Newbie question on multiple tables

2004-10-29 Thread Steve Grosz
I am just now getting the hang of searching through 2 tables, and getting the corresponding information using a pri & foreign key (ID1=ID1) kinda thing. How is this done with more than 2 tables? I had asked on a different forum, but I got some funky select statement using a left inner join, an