R
Ray S.
I have two large data tables. The field I want to compare is a text type
field that contains cost center information. One large table contains the
entire set of cost centers and related information that I want to analyze.
Another table contains a subset of the cost centers. How do I query to get
the "difference?" I know how to easily find the join of the tables (the
subset of the information in the larger table that includes only all the
records from the large file that are also in the smaller subset table). But I
can't figure how to get the data in the large table corresponding to the cost
centers that are NOT in the smaller subset of cost centers table. I hope this
is clear. Can anyone help me write the query?
field that contains cost center information. One large table contains the
entire set of cost centers and related information that I want to analyze.
Another table contains a subset of the cost centers. How do I query to get
the "difference?" I know how to easily find the join of the tables (the
subset of the information in the larger table that includes only all the
records from the large file that are also in the smaller subset table). But I
can't figure how to get the data in the large table corresponding to the cost
centers that are NOT in the smaller subset of cost centers table. I hope this
is clear. Can anyone help me write the query?