Hey,
I have a mysql query in a php script. The query simply goes something like this.
select * from blah,blahed,doo,boo where blah.blahid = blahed.blahid and doo.doid = boo.doid etc...
The problem i have come across is that it only displays results which have enteries in all the tables listed in the query. I would like the query to display an entry even if there is not data for it in the doo and boo table. Any ideas on how this can be achieved?
I have a mysql query in a php script. The query simply goes something like this.
select * from blah,blahed,doo,boo where blah.blahid = blahed.blahid and doo.doid = boo.doid etc...
The problem i have come across is that it only displays results which have enteries in all the tables listed in the query. I would like the query to display an entry even if there is not data for it in the doo and boo table. Any ideas on how this can be achieved?
Comment