General information
Category:
Coding, syntax & commands
>>SELECT DISTINCT Client_num, Client_SRC, FName, LName ;
>>FROM Ver ;
>>UNION ;
>>SELECT DISTINCT Client_num, Client_SRC, FName, LName ;
>>FROM Bal ;
>>INTO CURSOR Billable_Clients
>>
>>Again, the UNION will filter any rows that appear in both tables.
>What happens if Jimmy Jones is in both ver and bal? I want him to show up in the final table, but only once.
As long as 'Jimmy Jones' has exactly the same Client_Num, Client_SRC, FName, and LName in Ver and Bal, the UNION clause will produce just 1 row in the final table/cursor.
Note: If you actually WANTED to see the rows repeated, you change 'UNION' to 'UNION ALL'.
>BTW - I love your flag!
Thanks! I think the Marshallese did a good job on it, too.
Previous
Next
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