I'm using mysql. Is there any way to do a multiple-table select, but still return the results from table 1 if there are no matching rows in table 2? Something like "select table1.something,table2.something as something2 from table1,table2 where table1.table2id = table2.id" will only return the data from table1 if a row with the id in table1.table2id exists in table2.

The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to