I have 3 queries each with the following fields:
query1: serialcode1, amount3
query2: serialcode2, amount2
query3: serialcode3, amount2
I'd like to combine these all into one query listing all records together in one long list. Is there a way to do this without creating some kind of table first? I'd like to have one query with only two fields listing all the info from the 3 queries.
SELECT serialcode1 AS serialcode, amount3 AS amount FROM Query1
SELECT serialcode2 AS serialcode, amount2 AS amount FROM Query2
SELECT serialcode3 AS serialcode, amount2 AS amount FROM Query3;