Unix/Linux Go Back    


Programming Post questions about C, C++, Java, SQL, and other programming languages here.

MySQL join four tables!

Programming


Tags
intersection, join, mysql

Closed    
 
Thread Tools Search this Thread Display Modes
    #8  
Old Unix and Linux 01-24-2012   -   Original Discussion by yifangt
durden_tyler's Unix or Linux Image
durden_tyler durden_tyler is offline Forum Advisor  
Registered User
 
Join Date: Apr 2009
Last Activity: 9 May 2018, 9:38 PM EDT
Posts: 2,091
Thanks: 23
Thanked 388 Times in 351 Posts
Quote:
Originally Posted by yifangt View Post
Then the output should be:


Code:
B1 A1 O
B5 A1 O
If you extend this requirement to the 4 tables and the original data in them, then your query in your first post is correct.
You should see 14 records as per your expectation here.

tyler_durden
Sponsored Links
    #9  
Old Unix and Linux 01-25-2012   -   Original Discussion by yifangt
yifangt's Unix or Linux Image
yifangt yifangt is offline VIP Member  
UNIX.COM VIP Member
 
Join Date: Sep 2009
Last Activity: 18 May 2018, 1:31 PM EDT
Location: Saskatchewan, Canada
Posts: 528
Thanks: 345
Thanked 8 Times in 8 Posts
Thanks a lot, Tyler! I thought so now and really appreciate your input.
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Query to join two tables in SQL vanitham Programming 3 08-24-2011 06:22 PM
MySQL: Create a relation between two tables. semash! Programming 2 01-30-2011 03:45 PM



All times are GMT -4. The time now is 02:58 PM.