Re: The most elegant/efficient way to pull this SQL query

[(Hal]

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