[AccessD] comparing tables

ROTFLMAO

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Arthur Fuller
> Sent: 18 October 2004 20:22
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] comparing tables
> 
> 
> Susan Harkins wrote:
> 
> >I've got some SQL code that compares two tables and reports 
> on records 
> >that aren't in both tables. I did a bit of checking to be 
> sure, but I 
> >can't find any built-in Access feature that does this -- 
> anyone know of 
> >a wizard or something that I might have missed? I'd hate to 
> recommend 
> >something that's not necessary.
> > 
> >Susan H.
> >  
> >
> That must be some bitchin' code, rather like the SQL underlying such 
> statements from "Star Trek" as, "Scan the federation databases for 
> anomalies."
> 
> I would suggest that the set of records not found in both tables is 
> infinite, to say the least. :)
> 
> A.
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>