I need two fields from two different tables. I could either run two queries, or a single INNER JOIN query: $r1=mysql_query("SELECT fruit FROM fruits WHERE userid = 1"); $r2=mysql_query("SELECT beer FROM beers WHERE userid = 1"); --or-- $r=mysql_query("SELECT fruits.fruit, beers.beer FROM fruits INNER JOIN beers ON fruits.userid = beers.userid WHERE beers.userid = 1");
In general, which is preferable? I don't have access to the production machine to benchmark at the moment, but which is best practice? Thanks! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org