Merging result from three queries

[didajosh]

I have three queries fetching data like:
Query 1
ID---NAME-POSITION
01---Sam---001
01---Sam---002
02---Joe---002
03---Zach--003
-----------------------------------------------
Query 2
ID---EARN_CODE-----GROSS-----HOURS
01----AA-----------$10-------10.00
01----BB-----------$10-------10.00
01----CC-----------$10-------10.00
02----AA-----------$10-------10.00
02----CC-----------$10-------10.00
03----AA-----------$10-------10.00

-------------------------------------------------
Query 3
ID-----HIRE_DATE-----PLAN---EMPLOYER_AMT---EMPLOYEE_AMT
01-----01012009---DENTAL------$20----------$30
01-----01012009---HOUSE-------$20----------$30
01-----01012009---HEALTH------$200----------$300
02-----01012009---DENTAL------$20----------$30
02-----01012009---HOUSE-------$20----------$30
02-----01012009---HEALTH------$200----------$300
03-----01012009---DENTAL------$20----------$30
03-----01012009---HOUSE-------$20----------$30
03-----01012009---HEALTH------$200----------$300
-------------------------------------------------

When I run a select query on these three queries
with common ID's
------------------------------------
select ID,NAME,POSITION,EARN_CODE,GROSS,HOURS,HIRE_DATE,P LAN,EMPLOYER_AMT,EMPLOYEE_AMT
from query1,query2,query3
where
query1.id=query2.id
and
query1.id=query3.id
---------------------------------------

01-Sam-001-AA-$10-10.00-01012009-DENTAL-$20-$30
01-Sam-001-AA-$10-10.00-01012009-HOUSE-$20-$30
01-Sam-001-AA-$10-10.00-01012009-HEALTH-$20-$30
01-Sam-001-BB-$10-10.00-01012009-DENTAL-$20-$30
01-Sam-001-BB-$10-10.00-01012009-HOUSE-$20-$30
01-Sam-001-BB-$10-10.00-01012009-HEALTH-$20-$30
01-Sam-001-CC-$10-10.00-01012009-DENTAL-$20-$30
01-Sam-001-CC-$10-10.00-01012009-HOUSE-$20-$30
01-Sam-001-CC-$10-10.00-01012009-HEALTH-$20-$30

AND SO ON....

Is there some way I can stop the repetition of these values.

Any help would be great.

[Rabbit]

There's no repetition. Each record is unique. Without knowing your intent, there's not much we can help with.

[didajosh]

Hi,
thank you for replying.
Here is he kind of result I am looking for:

01-Sam-001-AA-$10-10.00-01012009-DENTAL-$20-$30
01-Sam-001-BB-$10-10.00-01012009-HOUSE-$20-$30
01-Sam-001-CC-$10-10.00-01012009-HEALTH-$20-$30

HOw can I get this kind of result.

[Rabbit]

You don't have the necessary fields to link your tables together to produce that result. How is Query 2 supposed to know that it should only use position 001 and not position 002? There's no way for it to know that unless you put position number in query 2. How is Query 3 supposed to know that the earn_codes map in that manner to plan? There's no way for it to know that unless you put earn_code in query 3.

Your structure can't support the query that you want to run because you are missing the required links between your recordsets.