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