here's another join question

[mcnewsxp]

tableA
----------
recid searchkeyfield

tableB
------------
recid tableArecid reporttypeid reportdate

tableC
------------
recid searchkeyfield reporttypeid reportdate

so I want rows from tableB and TableC that contain the reporttype and reportdate
on their own row

how?

tia,
mcnewsxp

[mcnewsxp]

SELECT a.LetterDate, LetterTypeLkup.LetterDescription
FROM CLetterHistory b INNER JOIN
LetterHistory a ON b.LetterID = a.RecID INNER JOIN
LetterTypeLkup ON a.LetterType = LetterTypeLkup.LetterTypeID
WHERE b.CID = @cid
UNION
SELECT LetterDate, LetterTypeLkup.LetterDescription
FROM LetterHistoryLog c INNER JOIN
LetterTypeLkup ON c.LetterTypeID = LetterTypeLkup.LetterTypeID
WHERE c.CID = @cid