I ran into an issue today with the WITHOUT keyword in a SELECT statement. In D3 the WITHOUT statement checks the entire field and if it is null completely it will add it to the list.
In UV, the WITHOUT option will check each value marked field. This way it will grab records where some values have something but just one of the values can be null and it would be pulled into the list.
SELECT INV WITHOUT LINE
ID: 111 LINE: 3]]5
In D3, this item would not be picked up because the entire LINE field is not null.
In UV this item would be picked up because there is a null entry in the LINE.