Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Records double in Query

Status
Not open for further replies.
lallen

lallen

Technical User
May 16, 2001
2
US
I created a Query which is pulling from 3 tables. I use a criteria to filter records but when I open the query all the records double.
any ideas on how to prevent this?
 
Sort by date Sort by votes
You can use Select Distinct clause to eliminate duplicates. The doubling occurs because one of the tables contains two records that match the join column on one of the other tables. You may want to verify that the relationships betwen the tables are defined properly in the join properties of the query. Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
514
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
combo
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
297
combo
combo
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
336
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
832
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top