>>>>If you would add a WHERE condition on the columns from the child table, it'll kill LEFT JOIN and it'll be like INNER JOIN.
>>>>
>>>>>Thanks Sergey. I thought that was correct. Something else was causing issues with the result.
>>>
>>>Thats correct I had done that.
>>>
>>>I have a table of parameters that I added to the select.
>>
>>I have a blog on this exact topic, take a look
>>
>>
Why LEFT JOIN does not bring all records from the LEFT table>
>That's a very nicely done blog post, Naomi ( and a reminder I should make it a point to read your blog more often as I may save me some time. )
Thanks, Charles, glad you like it. I have more blogs on this site
http://blogs.lessthandot.com/index.php/All/and there are some really good blogs on that site (not mine). You can check them in your leisure time.
If it's not broken, fix it until it is.
My Blog