I have two tables called RetailSales0607A and RetailSales0607B. Both tables contain the same field names
with data.
The field names are: StoreNumber, StateCode, and BottleSales.
RetailSales0607A contains 91,000 records.
RetailSales0607B contains an update of 92,000 records.
I need to select all of the new records that have been added by StateCode. There are 200 stores that can have sales in the different StateCodes which represent a Product.
The Primary Keys are Store Number and StateCode.
I need to pull sll of the records and activity by State Code for each particular store.
I know a Compound Select Statement which involves a Select within a Select is the way to go. But, I am not too interested in having a query that operates efficiently, I just need the data for requests sometimes that require me to present to management that data I have compiled is accurate. Sometimes a Select within a Select is not the way to go. But I need to learn to Compound Select Statements anyway and understand what I am doing.
Any Help out there.
MB92686
with data.
The field names are: StoreNumber, StateCode, and BottleSales.
RetailSales0607A contains 91,000 records.
RetailSales0607B contains an update of 92,000 records.
I need to select all of the new records that have been added by StateCode. There are 200 stores that can have sales in the different StateCodes which represent a Product.
The Primary Keys are Store Number and StateCode.
I need to pull sll of the records and activity by State Code for each particular store.
I know a Compound Select Statement which involves a Select within a Select is the way to go. But, I am not too interested in having a query that operates efficiently, I just need the data for requests sometimes that require me to present to management that data I have compiled is accurate. Sometimes a Select within a Select is not the way to go. But I need to learn to Compound Select Statements anyway and understand what I am doing.
Any Help out there.
MB92686