How can I consolidate these two tables into a single view?
Current:
=TableA=
fldP
fldX
=TableB=
fldY
fldZ
Required:
=TableC=
fldX
fldY
fldZ
The number of records in TableA and TableB are not the same, but there is a
1-to-1 correlation, top-down, between the tables, and I only need the first
n records of TableB, where n is the number of records in TableA. I'm not
sure if I need a union query, or some kind of join.
I tried this:
SELECT "fldY", "fldZ", fldX
FROM TableA
UNION SELECT fldY, fldZ, "fldX"
FROM TableB
close, but no cigar...