Hi there, I have two tables wich I need to join together. I use INNER JOIN but there is one problem. I have a master table, where is a column where I have a WHERE clause, wich I use as criterion for SELECT. The second table has some details for rows, wich fulfil the WHERE clause. I have an ID for rows, wihc are the same in both tables.
Problem is, that if I remove a row from secondary table, it does not come to query results any more, and I need to have all rows from master table even if there is no rows in secondary table. Sincerely, Putte Koivisto --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
