| creating flat file from a normalized table w/ QBE|
Some years ago I saw a query of a single normaiized table that gave a flat file answer table.
Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments.
Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable.
However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology.