Eliminating Duplicate Items

[The Chinaman]

Hi,

I have two tables in a database.

1. Has several colums one of which can contain duplicate names, other
colums
are unique to the ID.

2. Has a number of columns which have items from table one under a unique
Named product.

The query I need is for the items to be shown from table two but only those
which are unique to table two.

I have tried various permutations and keep getting all the same named items
returned
for each column in table two.

Thanks for your help

 

[Joseph Meehan]

Hi,

I have two tables in a database.

1. Has several colums one of which can contain duplicate names, other
colums
are unique to the ID.

2. Has a number of columns which have items from table one under a
unique Named product.

The query I need is for the items to be shown from table two but only
those which are unique to table two.

I have tried various permutations and keep getting all the same named
items returned
for each column in table two.

Thanks for your help

I can't for the life of me, figure out what you are doing. However it
sounds like it may be poor table design.

Could you be more specific about your table format.

You have how many tables?

What data is in each? (feel free to change the names to protect the
innocent.) List the fields in each table.

Do you have more than one field in a table listing the same type of
data? For example a sales table may have five "item" fields for recording
up to five items purchased at one time.

What relationships are there between the tables.

 

[The Chinaman]

Hi.

The details shown below will hopefully make it clearer. TableOne has around
2000 entries,
whilst TableTwo only about 25 but will grow very quickly.

TableOne:

OneID, OneName, One Category, OneFile, OnePictureFile

1 A M unique unique
2 A P unique unique
3 C Q unique unique
4 A R unique unique
5 C N unique unique

TableTwo:

TwoID, TwoName, CategoryM, CategoryN, CategoryO, CategoryP,CategoryQ,
CategoryR,

1 X A
A A
2 Z C
C



The two tables have a relationship join at there "IDs".

TableOne and TableTwo are filled in independantly.

Table two contains all text apart from ID, that is I have the Name under
each category which I have taken
from TableOne.

Thanks

 

[Joseph Meehan]

Hi.

The details shown below will hopefully make it clearer. TableOne has
around 2000 entries,
whilst TableTwo only about 25 but will grow very quickly.

TableOne:

OneID, OneName, One Category, OneFile, OnePictureFile

1 A M unique unique
2 A P unique unique
3 C Q unique unique
4 A R unique unique
5 C N unique unique

TableTwo:

TwoID, TwoName, CategoryM, CategoryN, CategoryO, CategoryP,CategoryQ,
CategoryR,

1 X A
A A
2 Z C
C

I was able to straighten out the format problem caused by word wrap in
the first table, but I could not figure out the second table.

Maybe if you tried it again with shorter names like:

2ID, 2Name, CatM, CatN, CatO, CatP, CatQ it might make it without the
wrap.