> Rather than allowing the NOT IN syntax and risking this type of "surprise" result, FoxPro does not support the NOT IN syntax against a table which supports NULLs.
I just tested this and didn't have problem writing a NOT IN query where the table supports nulls. I even based my comparison on the nullable field and made sure there was a null value.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only