Two Tables

[FengShui1998]

Hi,

I have two Tables in an SQL database, Table A and Table B. Both have the same column headings and I'd like to display both tables of A and B where STATUS='ACTIVE'. ANy ideas how to create the SQL Query.

Thanks.

fengshui_1998

 

[SQLSister]

Look at using a union query

 

[lespaul]

SELECT * FROM TABLEA WHERE STATUS = 'ACTIVE'
UNION
SELECT * FROM TABLEB WHERE STATUS = 'ACTIVE' Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[FengShui1998]

Thanks to both of you for your help.

fengshui_1998