Supplier Query

[Former Member]

Hi,

I am trying to generate a report for Suppliers which captures various fields in the supplier registration page. I wrote the query (pasted below)

Select

<%RESULTS%>

From

<%SCHEMA%>.FCI_MAS_VENDOR T1 LEFT OUTER JOIN

<%SCHEMA%>.FCI_UPP_USER_ACCOUNT T2 ON (T1.BUYER_CONTACT_OBJECT_ID = T2.OBJECTID) RIGHT OUTER JOIN <%SCHEMA%>.FCI_MAS_CONTACT T3 ON (T1.OBJECTID = T3.PARENT_OBJECT_ID)

Where

T1.INACTIVE = 0 AND

T3.PRIMARY_CONTACT = 1

<%ORDERBY%>

From this query i am not able to get the details from the third table. There are some suppliers who do not have any contacts registered. How do i generate a combined report?

Kind Regards,

Anshu

[Former Member]

Change your right outer join into a left outer join and try again

Howie Wexler

Crafty Systems, Inc,

www.craftysystems.com