Home Man
Search
Today's Posts
Register

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

MySQL join four tables!

Tags
intersection, join, mysql, programming

Login to Reply

 
Thread Tools Search this Thread
# 8  
Old 01-24-2012
Quote:
Originally Posted by yifangt
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
# 9  
Old 01-25-2012
Thanks a lot, Tyler! I thought so now and really appreciate your input.
Login to Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Shell script automation using cron which query's MySQL Tables kkpand Shell Programming and Scripting 3 4 Weeks Ago 10:12 PM
UPDATE COmmand post comparing 2 columns in 2 mysql tables siya@ Shell Programming and Scripting 1 06-10-2015 11:37 PM
Show only new and removed records by comparing to MySQL tables gvolpini Shell Programming and Scripting 0 05-30-2012 04:49 PM
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
How do you sync tables in mysql between two different servers? muay_tb Web Programming 2 12-21-2009 10:52 AM
create 'day' tables based on timestamp in mysql hazno UNIX and Linux Applications 2 03-10-2009 07:49 AM


All times are GMT -4. The time now is 08:43 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password