[HiTech RedNeck]

Don't forget that a lot of the records involved are going to be missing because of the flood.

The IRS should know however.

SELECT NAME, SSN from TAXPAYER where EMPLOYER = 'NOLA' and OCCUPATION = 'Police'

[FreedomPoster]

Bingo. My wife is a CPA, and deals with the IRS all the time. Upon hearing "your tax returns", in a list of what to grab when you're leaving your house to the elements, her comment was, "the IRS has copies of those".

[Lazamataz]

SELECT NAME, SSN, b.SCAMTYPE from TAXPAYER where EMPLOYER = 'NOLA' and OCCUPATION = 'Police'

SELECT NAME, SSN from TAXPAYER
left outer join KNOWN_CORRUPT_OFFICIALS on SSN,
KNOWN_SCAMS b
where EMPLOYER = 'NOLA'
and OCCUPATION = 'Police'
AND b.SCAMLOCATION = 'NOLA'