2005/11/5, Guy Brom <[EMAIL PROTECTED]>: > I have the following tables: > > languages > language_id int, > language_title varchar(80) > > objects > object_id int > object_language_id int > object_title varchar(100) > > I want to select ALL available languages, and match the translated object > (if it is exists) for a specific object_id. If it does not exists for that > specific language_id, I want to have NULL. >
Have a try with : Select language_id,language_title,object_id,object_title FROM languages LEFT JOIN objects ON objects.object_language_id=languages.language_id -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
