December 17th, 2012, 07:30 AM
Help needed finding data from 4 tables
I have searched and tried to locate this answer before posting.
I have a MYSQL problem
I have 4 tables with lots of different columns.
All 4 tables have the same ID column, a unique reference number:
Each table has one Row that point to the same ID
My problem is:
I need query all 4 tables and get the row back using the ID column
How do i do this.
This pulls other rows i don't want.
SELECT * FROM table1, table2, table3, table4 WHERE table1.ID = '$record'
I just want the 4 rows with the same ID
How can i do this?
December 17th, 2012, 08:07 AM
Hm, where to begin...
OK. In your own time read up on JOINs and UNIONs. Then find out what DDLs are in relation to MySQL. Then, if you're still stuck, come back to us with a more structured question, and an indication of what the output should actually look like.
December 17th, 2012, 08:22 AM
Originally Posted by cafelatte
Honest ive been reading and trying everything, im stuck.
I ve hit a brick wall.
All the JOIN answers relate to specific columns in each table,
but i have so many columns i can possible add all columns to the query. There has to be a simpler way.
I need a one liner to look up all 4 tables, and bring me back all the column data for that record: ID=165456
So something like:
Get ALL COLUMN DATA with ROW ID = 165456 from all the 4 TABLES
There is only one row in each table with the same ID Number
Still trying to solve this one.
December 17th, 2012, 08:46 AM
All of your tables share one, and only one, column in common. That's the criteria upon which they should be JOINed.
An inability to name all the columns in your query points to either poorly designed tables or chronic laziness.
December 17th, 2012, 09:19 AM
normally i don't like to just provide a solution to what is potentially a homework assignment, but this one is rather obviously not a homework assignment, and since you say you've already read up on joins and the penny still hasn't dropped, here ya go...
ON table2.id = table1.id
ON table3.id = table1.id
ON table4.id = table1.id
WHERE table1.id = '$record'
December 19th, 2012, 06:01 AM
I tried this, and Computer Says No
Is there an error in your syntax?
December 19th, 2012, 07:34 AM
Originally Posted by Marko2012
perhaps you would be so kind as to post the actual query that you ran to which your computer made this fascinating reply