Query to separate a table containing many sub tables


D

Darren Tecklenberg

I have a table containing 885,000 records with 116 sub table identifyers, but
without a field that can uniquely identify each of the sub tables. When I
import the data for this table I have a key field auto generated to uniquely
identify each record as identified below:-

Key Field 1 Field 2 Field 3
1 Table SITES
2 Fields SYS_REF SITENAME REGION
3 1 Site 1 North
4 1 Site 2 North
5 1 Site 3 South
6 Table PRODUCTS
7 Fields ITEM_REF ITEMTYPE ITEM NAME
8 000001 0001 TEA ENGLISH
BREAKFAST
9 000002 0002 COFFEE BEANS
10 000003 0001 TEA EARL GREY
etc...etc...etc...

What I want to do though is to create a query that pulls out each table
separately so that I can then run some more complex queries, alternatively be
able to import teh data and have it separate the tables out separately by
locating the Field 1 entries beginning with "Table *"
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top