You can UNION two SELECT statements together so long as they have the same field names in them. Example:<BR>SELECT myfield FROM mytable<BR>UNION<BR>SELECT myfield FROM myothertable<BR><BR>You could cheat it, too. Like this:<BR>SELECT mycrazyfield AS myfield FROM mytable<BR>UNION<BR>SELECT myfield FROM mytable
If the fields are the same and in the same order then yes a Union would work or if the 2 statements are related as in <BR>Select name_id, firstname, ... from table1 where names = 'fred'<BR><BR>select * from Table2 where Product_id = name_id<BR><BR>then you have a chance too join them
Just make it part of one big SELECT statement:<BR>SELECT table1.field1, table2.field2, table3.field3<BR>FROM table1, table2, table3<BR><BR>What specifically are you trying to do? Maybe we can help you to do it better.