Here is my normal join condition query
select C.[Search Name],SA.Name,'',SA.Address,SA.[Address 2],'','','',
SA.[Post Code]<pre lang="SQL"> from dbo.[CRONUS International Ltd_$Customer] C with (nolock)
inner join dbo.[CRONUS International Ltd_$Ship-to Address] SA with (nolock)
on C.No_=SA.[Customer No_]
Here I Getting result ..If I update above two tables
Then I try this query using "CHANGETABLE"
select C.[Search Name],SA.Name,'',SA.Address,SA.[Address 2],'','','',
SA.[Post Code],CT. [SYS_CHANGE_VERSION],CT.[SYS_CHANGE_CREATION_VERSION],
CT.[SYS_CHANGE_OPERATION],CT.[SYS_CHANGE_COLUMNS],CT.[SYS_CHANGE_CONTEXT]
From CHANGETABLE(CHANGES dbo.[CRONUS International Ltd_$Customer],
1) AS CT inner join dbo.[CRONUS International Ltd_$Customer] C
with (nolock) on ct. No_=c.No_ INNER JOIN dbo.[CRONUS International
Ltd_$Ship-to Address] SA
with (nolock) on C.No_=SA.[Customer No_] inner join
CHANGETABLE(CHANGES dbo.[CRONUS International Ltd_$Ship-to Address],
1) AS CP on CP.[Customer No_]=SA.[Customer No_] WHERE 1=1
Here I am not getting any result from this query..
How can I getting the result using changetable condition using condition
Please help me..