Select into 2 tables

m0119975

Hi,

I have 2 tables

example:

test1 with (id,name,active,character)
test2 with(id,name,active,color)

and i want to get all the names where active is equal to 1 and ordered by name.

If i want that only for table one i do this:

$query="SELECT name FROM test1 WHERE active=1 ORDER BY name ASC;

But if i want to get the names from test1 and test2 in one Query, how do i do that?

Thx.

m0119975

leatherback

How do these tables relate to eachother?

If you want to get data from two tables in one query, you have to have corresponding information, through which you can link these tables together.

Could it be that name,active are the same in both tables? Then perhaps consider merging them into one table?

m0119975

The Tables aren't really related, ther are just to teams of people with diffirent charachteristics to save (in this example color for test2 and char for test1).

And i want a list of al the people that are active sorted by name.

jasonmills58

hey, would that be this?

$query="SELECT name FROM test1, test2 WHERE active=1 ORDER BY name ASC;

Sxooter

You use a union.

select * from table1 union table2;

That's assuming color and character are the same data type. And you're on a database that supports unions.

Assuming you're on a database that doesn't support unions, you'll have to use a temp table:

create temp table unionator (id int, name text, active text, c text);
insert into unionator select from test1;
insert into unionator select from test2;
select * from unionator;