>>>> 2012/04/11 17:51 -0500, Peter Brawley >>>>
select b.peopleID, concat('(',p.fname,,')'), b.stateID, concat('(',s.state,')')
from bridge b
join people p on b.peopleID=p.peopleID
join state s on b.stateID=s.stateID;
<<<<<<<<
Since the names are the same in the tables, it works to use "USING", too, and
you are relieved of the burden of an alias:
from bridge
join people USING(peopleID)
join state USING(stateID)
If the fields "peopleId" and "stateID" are the only field names in common,
"NATURAL JOIN" also works.
from bridge
NATURAL join people
NATURAL join state
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
