i have a supertype-subtype:
subtypes: CLEARANCE, TAX CERTIFICATE, RECEIPT, BUSINESS CLEARANCE
each clearance subtype may have a TAX CERTIFICATE, how could i join using join?
in other words,
i want to join document>clearance and document>tax certificate into a SINGLE view