I'm trying to Relate to two tables using phpMyAdmin using the book, Mastering phpMyAdmin (October 2004 edition). I do not see a Relation View available to me (See pg 138).
I'm successfully browsing an individual table but cannot figure out how to join multiple tables.
Help!
Thanks, Greg

try this

SELECT * FROM t1 LEFT JOIN (t2, t3, t4)
ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)


SELECT t1.name, t2.salary
FROM employee AS t1 INNER JOIN info AS t2 ON t1.name = t2.name;

SELECT t1.name, t2.salary
FROM employee t1 INNER JOIN info t2 ON t1.name = t2.name;