sounds like this to meSELECT TOP (100) PERCENT COALESCE(dbo.[sa-earnviewpost].[sa-no],dbo.[sa-earnviewunpost].[sa-no]) AS [sa-no], COALESCE(dbo.[sa-earnviewpost].[sa-seq-no],dbo.[sa-earnviewunpost].[sa-seq-no]) AS [sa-seq-no], dbo.[sa-earnviewpost].Posted, dbo.[sa-earnviewunpost].Unposted, dbo.[sa-earnviewunpost].[sa-seq-no] AS Expr1, dbo.[sa-earnviewunpost].[sa-no] AS Expr2FROM dbo.[sa-earnviewpost] FULL OUTER JOINdbo.[sa-earnviewunpost] ON dbo.[sa-earnviewpost].[sa-no] = dbo.[sa-earnviewunpost].[sa-no] AND dbo.[sa-earnviewpost].[sa-seq-no] = dbo.[sa-earnviewunpost].[sa-seq-no]ORDER BY COALESCE(dbo.[sa-earnviewpost].[sa-no],dbo.[sa-earnviewunpost].[sa-no])
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs