samthomasny
New member
- Local time
- Today, 03:08
- Joined
- Aug 27, 2014
- Messages
- 3
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 now "AP" Or "PO" And Not like "FC*" is returning me both Ord2 & 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 now "AP" Or "PO" And Not like "FC*" is returning me both Ord2 & Ord3
Last edited: