select statement....

[Anon]

Hi,

I'm a bit confused here... I need to select everything from multiple tables, but am not sure why my query won't execute.

I have 3 tables in one database.

table_1
table_2
table_3

Query: select * from table_1, table_2, table_3 where name = "someName";

The data in those tables is different.

May be I need to use joins, to join 3 tables? Can't figure out how.

[Anon]

Try this:-

select from table_1 where name = 'someName'
union
select from table_2 where name = 'someName'
union
select * from table_3 where name = 'someName';

Hope this helps,

chrber

[Anon]

Thanks, but it gives me SQL syntax error near Union

[Anon]

Union is not supported by MySQL. If thats what your suing you wont be able to do this. You might have to consider doing this in PHP, or creating a temp table. Neither of which are good options.

[Anon]

Does you tables have any columns that are common?

Say you have three tables:

names with columns: id, name
emails with columns: id, names_id, email
urls with columns: id, names_id, url

where the 'emails' and 'urls' tables are linked to 'names' table id column with their names_id columns.
If you want to select name, email and url for name='rune', then you can make this query:

SELECT name, email, url FROM names
LEFT JOIN emails ON emails.names_id = names.id
LEFT JOIN urls ON urls.names_id = names.id
WHERE names.name = 'rune';

or

SELECT name, email, url FROM names, emails, urls
WHERE names.id = emails.names_id
AND names.id = urls.names_id
AND names.name = 'rune';