SQL to DDS help

[Michael.Clinch@xxxxxxxxxxx]

I have the following SQL statement that returns what I desire.


What I need to figure out is how to create one logical file with the same
results.


SELECT DH90CTRD.LAST AS LastName,
    DH90CTRD.FIRST AS FirstName, DH90CTRD.NS AS Unit,
    DH90CTRD.DSCDTE AS TermDate,
    DH90CTRD.MEDRC AS MedRecNum,
    DH90CTRD.INST AS Inst
FROM DH90CTRD
UNION
SELECT DH90CTYK.Last AS LastName,
    DH90CTYK.FIRST AS FirstName, DH90CTYK.NS AS Unit,
    DH90CTYK.DSCDTE AS TermDate,
    DH90CTYK.MEDRC AS MedRecNum,
    DH90CTYK.INST AS Inst
FROM DH90CTYK
UNION
SELECT DH90DTRD.Last AS LastName,
    DH90DTRD.FIRST AS FirstName, DH90DTRD.NS AS Unit,
    DH90DTRD.DSCDTE AS TermDate,
    DH90DTRD.MEDRC AS MedRecNum,
    DH90DTRD.INST AS Inst
FROM DH90DTRD
UNION
SELECT DH90DTYK.Last AS LastName,
    DH90DTYK.FIRST AS FirstName, DH90DTYK.NS AS Unit,
    DH90DTYK.DSCDTE AS TermDate,
    DH90DTYK.MEDRC AS MedRecNum,
    DH90DTYK.INST AS Inst
FROM DH90DTYK


Thanks in advance.
Michael J. Clinch
Programmer Analyst
Bureau of Information and Telecommunications
Pierre, South Dakota