Select from 2 tables

[erme]

Hi, New to SQL so bare with me!

 

I have 4 tables and want to grab info from all of them in the same way as if all the tables info were in 1 table.

 

Basically want something like this

 

SELECT * FROM Table1 & Table2 & Table3 & Table Where blah blah blah

 

Many thanks

[premiso]

SELECT * FROM table1, table2, table3, table4 WHERE condtion=something

 

You may want to look into joins, but yea. There you go.

[RussellReal]

to bridge off of what premiso said, you'd do like WHERE table1.id = table2.id etc etc

[erme]

to bridge off of what premiso said, you'd do like WHERE table1.id = table2.id etc etc

 

This doesn't seem to work. Am I doing something wrong?

 

SELECT DISTINCT County FROM Table1, Table2 WHERE Table1.County = Table2.County Order by County ASC

[RussellReal]

no that looks right.. try this..

 

SELECT * FROM Table1 JOIN Table2 ON (Table1.County = Table2.County) WHERE ETC ETC ETC

[erme]

Still dosent seem to work   

[erme]

Do the field names need to be different in each table? Like County1 and County2

[RussellReal]

nope.. is your table names literally "Table1" and "Table2"?

[erme]

One's called Locations, other one is called Places. But have been changing them from Table1 .. when testing

[RussellReal]

use the correct table names in the query.

[erme]

Even if I do this it doesn't work

 

SELECT * FROM Locations, Places

 

where as this works:

 

SELECT * FROM Locations

[erme]

Got it working. For some reason UNION worked