I have two tables which has been brought in from Microsoft Access. Table 1 is OUTL0607A and Table 2 is OUTL0607B.
The two tables have been linked together using the keys, State Code, and Store Number which are fields in both tables. The difference between the two tables is about 810 records. I need to find matches between the two Tables. I am trying to do a Sequel View by placing these two tables in the SQL Management Express. I am using a SELECT DISTINCT. I need for the query to pull the records that have matches for State Number and State Code but I only want the records to show only once and not be duplicated.
Table 1 has 91,810 records and Table 2 Has 91,000 records so I know there have been some field added amounting to 810 records.
Any help is appreciated.
Thanks
jjc3397
The two tables have been linked together using the keys, State Code, and Store Number which are fields in both tables. The difference between the two tables is about 810 records. I need to find matches between the two Tables. I am trying to do a Sequel View by placing these two tables in the SQL Management Express. I am using a SELECT DISTINCT. I need for the query to pull the records that have matches for State Number and State Code but I only want the records to show only once and not be duplicated.
Table 1 has 91,810 records and Table 2 Has 91,000 records so I know there have been some field added amounting to 810 records.
Any help is appreciated.
Thanks
jjc3397