Regarding SQL Query

[Goodluck]

Hello,

I am creating two temporary tables "tableCon11" and "tableCon12" having same fields "stn_cde", "emp_dept_desc", "amount". I have kept one table empty and other table containing a single record. I have to combine these two tables.

How can I write the query? Please guide.

Thank you.

[Jordan]

If one table is empty what is there to combine?

[Goodluck]

Hello,

Even if there is one table empty and another containing a single record, when I will run the query to combine these two tables then the resulting resultset must contain a single record. But when I actually used to run it, it shows no record. That's why I need a format for the query to combine these two tables having the same fields. Please guide.

Thanks.

[acccapulco]

You can refer to your tables as tableCon11.stn_cde and tableCon12.stn_cde
ex: SELECT * FROM tableCon11, tableCon12 WHERE tableCon11.stn_cde=tableCon12.stn_cde;