[SOLVED] right outer join

[zohab]

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.

 

[fenway]

Sure... join the table with a left join using user_id in the on clause, then use IFNULL() for each field.