Two tables with no primary Key but a common field

[tdubs]

Hi guys,

I am having problem with a query.

I have to tables. One named wire and the other named Input.
As my title says there is not unique ID for the tables to relate.. the only thing to relate is one ID where is not unique for all the rows

In the Wire Table I have 3 rows using the same ID, lets say 123.
In the Input Table I have 1 row using the same ID as above, i.e. 123

I need to select a couple of fields from Wire Table and 1 field from Input Table
The only relationship I have is the ID 123.... since the ID in Wire Table is repeated in 3 rows.... I would like to use the same value from the Input Table to be the same for the 3 rows in the other table.. Below is an example:

Wire Table:

ID Group
123 A
123 B
123 C

Input Table
ID Description
123 Analog


My wanted result would be

Group Description
A Analog
B Analog
C Analog


I tried using the Left join or Join function, but somehow the resulting table has many duplicates of the rows...such as:

Group Description
A Analog
A Analog
A Analog
A Analog
A Analog
B Analog
B Analog
B Analog
B Analog
...

Any Idea on whats going on and how can i solve this problem????

Thanks in advance. Your Help is much appreciated

 

[ejstefl]

Try using SELECT DISTINCT