SQL Help

[churchill]

Hi,
I have two lots of data one contains a list of everything sold and the other contains alist of everything they have thought we have sold. I need to compare the two lots of data to find those that dont have a match i.e. those which they think we have not sold. i also want to be able to find those that do have a match. And those that match but not 100%.

I also have 19 tables of data and from that i want to find a common link between any three of them. So i can find all customers who have purchased under any three of the table headings.

Can anyone help me please.

Im so stuck and dont know where to go from here. Any ideas would be welcome. Please help a girl in her time of need.

 

[Uncle Gizmo]

I also have 19 tables of data.

Is the layout of these tables Exactly the same? Could it be easily be made the same? If so it would probably help if you pull them together into one big table.

 

[churchill]

SQL Queries

No as each table contains the same headings but different data, and in one table would be difficult to read.

The 19 tables work and displays the list i wanted it to. But i need to sort through the tables and find certians customers, or customers who could be in any 4 ,3 or 5 tables.

 

[KenHigg]

Just a quick comment - Looks like you are experiencing one of the many pitfalls of not normalizing your data...

 

[churchill]

Huh!

pardon, what does that mean. I can write java programs im just not very good at access unfortunalty. Can you help me at all. Im really stuck

 

[KenHigg]

Hum...

You said you have multiple tables with similar headings. I'm guessing that you should put all of this data in one table, and use a separate fld, maybe a category type fld to distinguish the sub-groups of records.

Maybe you could search here in this forum on 'normalization', or maybe Google it.

 

[Uncle Gizmo]

First of all, you are not dumb, you are posting here, and trying to sort out the problem. You have already said that you are a java programmer so obviously you must have some brains.

However you are in danger of acting dumb!

I don't know anything about your database problem, only what you have posted here. And it appears to me that you have common tables with common field types that you should be able to combine into one table. Even in your answer, you reinforce this suspicion.

The reason I made the suggestion, was because I have seen many similar posts to yo..u...r....s.... and I thing I've said it before!

 

[churchill]

Sql

the database with 19 tables is sorted thanks for your adivce guys.

But im stuck with another task and wondered if you were able to help me.

i have one table containg the data from two seperate spreadsheets, they contain all the same fields but what i have done is said which spreadsheet they originally came from. I wanted to be able to sort that data and find those that match and those that dont. Is this possible.

Ive tired the unmtached and matched queries.
Ive tried SQL queries as well and none of them do what iw ant them to do.