Re: Easy JOIN question for the pros

From: James <geniosity_at_gmail.com>
Date: 8 Jun 2005 08:26:50 -0700
Message-ID: <1118244410.150961.280720@g43g2000cwa.googlegroups.com>

In Case anybody reads this, I actually used a SubQuery for the field I required. So, my final solution looked like this:

SELECT DISTINCT TABLE1.mainID,

	 TABLE2.ap_UniqueName,
        (SELECT DISTINCT innerTABLE1.oidp_Value
        FROM us_OrganizationIDPartTab innerTABLE1
        WHERE TABLE4.oid_Ids = innerTABLE1.lvId
        AND TABLE4.mainID = innerTABLE1.mainID
        AND (LOWER(innerTABLE1.oidp_Domain) = 'JACK')) JACK_FIELD
FROM PurchaseOrderTab TABLE1,
	 ApprovableTab TABLE2,
	 POLineItemTab TABLE3,
	 SupplierTab TABLE4

WHERE TABLE2.mainID = TABLE1.mainID

AND TABLE1.po_LineItems = TABLE3.lvId
AND TABLE1.mainID = TABLE3.mainID
AND TABLE3.poli_Supplier = TABLE4.mainID

AND (TABLE2.ap_Active = 1) Received on Wed Jun 08 2005 - 10:26:50 CDT