Rhino wrote: > Okay, you've convinced me that you need some Left Joins ;-) > > I think you'll have to use a mix of Left Joins and Inner Joins. In > the cases where you need a row even if something doesn't exist, like > a subject who has an address but no phone number, use a Left Join. In > any case where a row shouldn't appear unless there is a match between > the keys, use an Inner Join. I wish I could be more precise than that > but I don't know your particular business as well as you do. > > To help clarify the difference between Inner and Left Joins, I'm > going to paste in part of an email I wrote last week helping someone > with this point. You probably know a lot of the things in there > already but I think this should help you understand the difference > between an Inner Join and a Left Join. > > Please post again if you anything here isn't clear or you still need > help despite my "instant tutorial".
Mix of joins solved my problem, i use left joins for addresses and phones and inner joins for field of work. Thanx for tutorial, is's been wery helpful and now i can say that i Understand ;) -- Regards Marko -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]