Ask Your Question

Duplicate primary key L_ListingID

asked 2018-09-27 15:11:54 -0600


I was trying to download records from rets for IL_PAAR_COM, When I download there are multiple records for same L_ListingID. Some of the L_ListingID which I found duplicate keys are (1000557, 7004544, 1001315, 4054301..) Is there a another column for unique ids? Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-09-27 16:53:43 -0600

If you exclude these two fields from your select: T_tax_db_id T_list_tax_property_id, it will remove the duplicate listing records. I will see about getting the data fixed.

edit flag offensive delete link more


Thanks, Appreciate your help. :)

Rajeeb gravatar imageRajeeb ( 2018-09-27 17:35:57 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-27 15:11:54 -0600

Seen: 432 times

Last updated: Sep 27 '18