Left Join Question

[fnbcprog]

This works but would there be a more efficient way of doing this?

$result = mysql_query("SELECT * FROM nbamdf
LEFT JOIN nbaddr ON nbamdf.id_nbamdf = nbaddr.id_nbglobal
LEFT JOIN nbphone ON nbamdf.id_nbamdf = nbphone.id_nbglobal
LEFT JOIN nbamdf2 ON nbamdf.id_nbamdf = nbamdf2.id_nbamdf
WHERE nbamdf.id_nbamdf = '$_GET[agentID]'");

[tomhath]

The problem I see with this query is that you'll get many more combinations than you want (e.g. if you have two addresses and three phones you'll get six rows back, times as many rows from nbamdf2 that are returned).

I'd probably keep these as four separate queries instead of one join.