1 Replies - 930 Views - Last Post: 27 October 2015 - 05:16 AM

#1 DADDYCARDONA  Icon User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 207
  • Joined: 04-July 10

Duplicate Records

Posted 26 October 2015 - 09:22 PM

I just used the query wizard to make a table from 5 tables. However, I get duplicate records which makes no sense why this is happening. It is a prototype this is the code from the query builder wizard.

 
SELECT Cases.[Case Number], Cases.[Last Name], Cases.[Zip Code], [Social Wokers].[Last Name], [Social Wokers].Office, Attornies.[Last Name], Attornies.Office, [Available Foster Parents].[Last Name], [Available Foster Parents].Zip
FROM [Available Foster Parents], [Social Wokers] INNER JOIN (Attornies INNER JOIN Cases ON Attornies.ID = Cases.[Attorney Assigned]) ON [Social Wokers].ID = Cases.[Case Worker Assigned];





Is This A Good Question/Topic? 0
  • +

Replies To: Duplicate Records

#2 DADDYCARDONA  Icon User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 207
  • Joined: 04-July 10

Re: Duplicate Records

Posted 27 October 2015 - 05:16 AM

I just redid the query with query wizard and it fixed all my problems thank you myself for trying.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1