Jump to content

[SOLVED] right outer join


zohab

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.