how can it be confusing ? nobody ever experienced it before? simply when you join 2 tables together if you get 5 records from the second table the first table will display 5 times aswell
> Hi Daniel, > > I am still not sure what exactly you are trying to achieve. > > If you specify the WHERE condition correctly (or ON or USING for the > LEFT JOIN) then there is no duplicate entry. > > I believe what you are asking has more to do with the way how to > present the > data in the output. > > Best regards > > Nils Valentin > Tokyo/Japan > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]