Re: [PHP] MySQL Left Join Question

I'm not clear whether you are saying you get the records where there is a match and no non-matching records, or simply no records at all! What happens if you take out the WHERE clause, do you get all the records from p being displayed with NULLs for c.projectid where no match exists? Nick On

[PHP] MySQL Left Join Question

This may not be the best place to ask this question, but I'm running into a problem when I perform a left join sql statement in PHP. The sql statement is as follows: SELECT p.id pid,p.designID,p.project_name,p.node,p.received,p.lots,p.ugfootage,p.aerialf ootage,p.node,c.* FROM projects as p LEFT