You can accomplish much the same thing in Data Compare by creating a
uniquely-indexed view on the server out of your query and then using Data
Compare to compare the indexed view in each database.
Hopefully this help some.
Red Gate Technical
"Shai Goldberg" <gshai(RemoveThis)@shamir.co.il> wrote in message
> Is there a way, when using the automation of the SQL Data Compare, to
> compare data from several tables using a select statement instead of table
> or view name.
> The select statement use I want to use may include inner joins and also
> where cluase.
> I have managed to perform a data compare with automation and by selecting
> some fields and not a Primary Key