Re[2]: [firebird-support] Find duplicate multi-row entries

Set, Thank you. This definitely does something...to be honest I'm not certain exactly what... I'm definitely going to need to study this for a while. I sincerely appreciate the effort - though I think I am going to reconsider my table structure. -- Daniel On 9/28/2017 1:42:18 PM, "setysvar

Re: Re[2]: [firebird-support] Find duplicate multi-row entries

Sure it is possible to write such a query: select r.NODE, r.ROUTE_INDEX, r.LINK_NODE, r.QUALITY from routes r left join route_history rh1 on r.node = rh1.node and r.route_index = rh1.route_index and r.link_node = rh1.link_node

Re: Re[2]: [firebird-support] Find duplicate multi-row entries

Please define "set" Regards,Karol Bieniaszewski null

Re[2]: [firebird-support] Find duplicate multi-row entries

On 9/27/2017 9:20:54 PM, "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" wrote: group by + having is your friend. E.g. Select field1, field2, count(*) From tablex Group by field1, field2 Having count(*)>1 But in your scenario i do not know if