Im havin a heck of a problem. I have a database with 800 tables. All the tables are the same with the same fields. Each table is a survey form. My table structure is as follows:
FPC_Code | FPC_Product | Price | oos | osd
the above sturucture is the same for all my tables. Now what i have to do is as follows:
I have one master table Which conatins a range of prices which each product can fall between. FPC_Code being my primary key:
FPC_Code | LowerPrice |upperPrice.
Now i have to compare each product in my master table with all the 800 tables and check whether the price in each table falls with in the 'UpperPrice' and 'Lowerprice' price bracket of the master table. Pls note that each table contains 200 products.
I have an idea how to start it but need a lil jump start.
Any help will be much appreciated.