[SOLVED] getting all values from three different tables .. JOIN problem?

[krio]

I'm learning mysql and have been trying to get this working, but an error always comes up no matter how I try it - or it just doesn't show anything from the table.

 

I have 3 tables, all with the same amount of columns and name of columns

 

I want to list all the values in alphabetical order by title

 

Tables: General - Temp - Location

 

Columns:  id - url - title - description

 

How would you  write the select statement?

 

I have tried numerous ways and can't figure it out... I'm guessing it would look something like

 

SELECT * FROM General JOIN Temp ON General.title = Temp.title JOIN Location ON Temp.title = General.title

 

I have played around extensively with changing the values like Temp.title = General.title and that doesnt seem to help

 

Any ideas?

 

Thanks!

 

[krio]

I forgot to add the ORDER BY ASC, but I jsut want to get the select working as it is the most imporant

[Mark1inLA]

SELECT 
General.id,
General.url,
General.title,
General.description,
Temp.id,
Temp.url,
Temp.title,
Temp.description,
Location.id,
Location.url,
Location.title,
Location.description
FROM 
General INNER JOIN Temp
ON General.id = Temp.id
INNER JOIN Location
ON Temp.id = Location.id
ORDER BY
General.title

 

Will this work?

[krio]

hey thank you for the response!

 

it is showing a result, but it is only showing items from the general board.. and it is only showing the amount of entries from the temp board...

 

very weird!

 

 

[Mark1inLA]

Ahh, its probably because you need to use identifiers for the other columns like Temp.id as `temp.id`. I shouldve noticed that before submitting it.

[krio]

working thanks!