GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Any SQL gurus in the house? Can you help?

PPC · 09-25-2008, 12:09 AM

export both into excel

and select all data then goto toolbar Data > Filter > Advanced Filter

click copy to another location change the copy to range ... click unique records only then hit ok

but hey, I'm no SQL guru :p

(btw this will only work for up to like 65k, excels row limit)

09-25-2008, 12:09 AM
PPC Registered User Join Date: Jun 2007 Posts: 60	export both into excel and select all data then goto toolbar Data > Filter > Advanced Filter click copy to another location change the copy to range ... click unique records only then hit ok but hey, I'm no SQL guru :p (btw this will only work for up to like 65k, excels row limit) __________________ Pay Per Click Last edited by PPC; 09-25-2008 at 12:10 AM..