Ask Your Question
0

Duplicate primary key L_ListingID

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

Rajeeb gravatar image

RETS Url: http://cmls.rets.paragonrels.com/rets...

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
0

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

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

Comments

Thanks, Appreciate your help. :)

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

Question Tools

1 follower

Stats

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

Seen: 127 times

Last updated: Sep 27