Recommended Answers
Jump to PostI do not know if i got you right, anyway you said that a clearance may have a tax certificate sounds to me that you cannot make direct reference between the tax certificate and document but thru clearance table. if this is the case you will have something like this.
…
Jump to PostWhen you say document>certificate what exactly is certificate for you here, because i do not see any certificate table?
Jump to PostOk.
SELECT * FROM DOCUMENT INNER JOIN CLEARANCE ON CLEARANCE.DOC_ID = DOCUMENT.DocNo LEFT OUTER JOIN SEDULA ON SEDULA.DOC_ID = CLEARANCE.DOC_ID
Try that.
Jump to PostSELECT * FROM DOCUMENT INNER JOIN CLEARANCE ON CLEARANCE.DOC_ID = DOCUMENT.DocNo LEFT OUTER JOIN SEDULA ON SEDULA.DOC_ID = CLEARANCE.DOC_ID INNER JOIN PERSON ON PERSON.PersonID = DOCUMENT.PesonID INNER JOIN OFFICER ON OFFICER.OfficerID = DOCUMENT.OfficerID
notice that in order to get information from person in officer table you have …
All 13 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.