Skip to Content
Former Member
May 08, 2016 at 05:22 PM

Select Query for FMS


See Attached - I need a query that selects an Item Alias from a UDT.

In this query the SiteID may be blank in some cases in the UDT.

So there would be a BP Code, Item Code, and SiteID(again in some cases the SiteID may be blank in the UDT and then I only want the BP Code and Item Code.

BP Code Item Code Site ID ALIAS

AA 123 1 Fred (Fred would be selected)

BB 234 2 Dan (Dan would be selected)

CC 345 John (John would be selected even though it is blank)

My Query: