Left Outer Join

Kinetic ERP
,
1

Hi, Ive been doing BAQs for a while and ive never had a need to do a left outer join. I can’t figure out how to do it in the new ERP system.

What I’m trying to do is create a BAQ showing the purchase parts that have no supplier in epicor, this is what i have so far.

select  
	[Part].[PartNum] as [Part_PartNum], 
	[Part].[PartDescription] as [Part_PartDescription] 

from Erp.Part as [Part]
inner join Erp.VendPart as [VendPart] on 
	  Part.Company = VendPart.Company
	and  Part.PartNum = VendPart.PartNum
inner join Erp.Vendor as [Vendor] on 
	  Vendor.Company = VendPart.Company
	and  Vendor.VendorNum = VendPart.VendorNum

many thanks

Yasmine

2

There’s a drop down on the bottom right corner after you select the join (the line with the box in it). It doesn’t say left join like SQL, it spells out “all from x table” or something like that. You’ll see the shape of the box on the join line change to show you which table is the other one.

Edit: Now that I’m at a computer here’s a screen shot

image
image762×459 19.2 KB

7 Likes