MySQL MULTIPLE SELECT

ab4net

hi,
thanks you in advance 🙂
i wanted to ask how to select a name (e.g. Jhon) from 2 tables:
Table A:
id, name, details
Table B:
id, name, details

at the same time ...
by 1 SQL Statement ??!!

and thanks ...

Shrike

The MYSQL manual explains it all pretty well.

SELECT table1.column, table2.column
FROM table1, table2

You can also use an alias for each table name to save typing it out every time.

SELECT t1.column, t2.column
FROM table1 AS t1, table2 AS t2

ab4net

The problem in this that the result comes as 2 columns but i want to get the results as 1 column .. is it possible .?
and thanks alot ...

Lars_Berg

select name from a
union all
select name from b

ab4net

thanks alot ...
but i have tried and wrote:

select name from table1 where name like '%$q%'
union all
select name from table2 where name like '%$q%'

but the problem, i got an SQL error says:
you have an error in your SQL syntax near 'union all select name fromm table2 where name like '%$q%' at line 2

so what was the matter .. ?

thanks alot in advance ...

Lars_Berg

Presumably you have a very much outdated vesion of Mysql. Upgrade.

ab4net

ya, thanks alot, it work fine i have tried it on a newer version ...
can you please advice about a direct link to download automatic installer for the MySQL on my IIS Web Server (Windows) ...

Greatfuly thanks ...