zohab Posted January 14, 2008 Share Posted January 14, 2008 hi all i have 2 tables and i need sql query to fetch records as per condition mention below. "table1" /* Following are the column name */ primary_id user_id first_name last_name email phone status "table2" /* Following are the column name */ user_id first_name last_name email phone If record has user_id value then show first_name,last_name,email & phone from "table2" table otherwise show it from "table1" any ideas? thanks in advance. Link to comment https://forums.phpfreaks.com/topic/85910-solved-right-outer-join/ Share on other sites More sharing options...
fenway Posted January 14, 2008 Share Posted January 14, 2008 Sure... join the table with a left join using user_id in the on clause, then use IFNULL() for each field. Link to comment https://forums.phpfreaks.com/topic/85910-solved-right-outer-join/#findComment-438770 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.