Can someone please help me on this? In the below screenshot I want the sql qry to return only 'Ord3'
Ord1 must be excluded because of 'FC' (easy <> "FC")
Ord2 must be excluded because one of those records have 'FC' (struggling)
Ord3 must be included since it doesnt have any 'FC' records
Right...
Working with two tables - tbl_A_OrdData & tbl_B_ShipData
tbl_A have all the orders placed, but tbl_B only have the orders that got shipped. I'm trying to create a query that will show me all orders that got placed for a particular criteria and if the order find a match in tbl_B to give me the...