I have three tables which have the same structure but different datasets. Basically the tables hold data on products and i want to produce one list that gives me the style no and the total qty in stock, being the the sum of the individual entries on each table. Also within each table the style no may be listed more than once, on the final query i want just one entry showing the total of all entries from all tables. Hope this makes sense. Any help appreciated.