Welcome to WebmasterWorld Guest from 54.205.88.118

Forum Moderators: open

Need help joining tables

   
5:31 am on Jun 26, 2011 (gmt 0)

5+ Year Member



I have to join tables based on conditions

table : main
condition_field
unique_id
username

table : a
unique_id
companyname

table : b
username
companyname

If main.condition_field = "X"
I need to Left Join table a on main.unique_id = a.unique_id


Else if main.condition_field = "Y"
I need to Left Join table b on main.username = b.username

So far I only have this query joining 2 table main and table a

SELECT main.*, a.* FROM main LEFT JOIN a ON main.unique_id = a.unique_id where main.unique_id='X'


Please Help
4:18 pm on Jun 27, 2011 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



Probably easier to use an IF statement or CASE function- actual implementation depends on your specific DB.
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month