General information
Category:
Coding, syntax & commands
>>>I have decided to force myself to learn SQL, therefore, the resultant headache from which I currently suffer. This shouldn't be this hard! I have two tables, one with 82 records and one with 80 records. The output I want is simple. I want the 2 records in table A that are not in table B.
>>>
>>>Please don't make me feel too stupid.
>>
>>Select * from TableA where TableA.KeyID not in (select TableB.KeyID) into cursor MyCursor
>>
>>KeyId in both tables need to be same data type and length.
>
>sorry...
>
>Select * from TableA where TableA.KeyID not in (select TableB.KeyID from TableB) into cursor MyCursor
GOT IT! Thanks. Now comes the fun part. Figuring out mismatches based on additions and subtractions of some fields.
Thanks again.
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