SQL Query to compare two table values?
The bellow tables are there:VPRC_13:
CREATE TABLE [VPRC_13] (
[RptUnitTypeID] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Rpt_Unit] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[YYYYMM] [numeric](4, 0) NOT NULL ,
[Tree_Ind_ID] [Tree_Ind_ID] NOT NULL ,
[proj_adopt] [datetime] NULL ,
[agree_sign] [datetime] NULL ,
[rect_inifund] [datetime] NULL ,
[amt_inifund] [numeric](13, 2) NULL ,
[disp_pip] [datetime] NULL ,
[pip_app_date] [datetime] NULL ,
[per_elect] [numeric](5, 2) NULL ,
[per_women] [numeric](5, 2) NULL ,
[R_Index] [int] NULL ,
[CDATE] [datetime] NULL ,
[MDATE] [datetime] NULL ,
CONSTRAINT [PK_TR_VPRC_13] PRIMARY KEY CLUSTERED
(
[RptUnitTypeID],
[Rpt_Unit],
[YYYYMM],
[Tree_Ind_ID]
) ON [PRIMARY] ,
CONSTRAINT [CK_TR_VPRC_13] CHECK ([per_elect] < 100),
CONSTRAINT [CK_TR_VPRC_13_1] CHECK ([per_women] < 100)
) ON [PRIMARY]
GO
VPRC_60:
CREATE TABLE [VPRC_60] (
[RptUnitTypeID] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Rpt_Unit] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[YYYYMM] [numeric](18, 0) NOT NULL ,
[shg_code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[name_of_SHG] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[shg_code1] [bigint] NOT NULL ,
[tally_ref_no] [numeric](18, 0) NULL ,
[tally_shg_no] [numeric](18, 0) NULL ,
[dt_for] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_VPRC_60] PRIMARY KEY CLUSTERED
(
[RptUnitTypeID],
[Rpt_Unit],
[YYYYMM],
[name_of_SHG]
) ON [PRIMARY] ,
CONSTRAINT [shguniq] UNIQUE NONCLUSTERED
(
[shg_code]
) ON [PRIMARY] ,
CONSTRAINT [shguniq1] UNIQUE NONCLUSTERED
(
[shg_code1]
) ON [PRIMARY]
) ON [PRIMARY]
GO
I want to select VPRC_13.proj_adopt greater then VPRC_60.dt_for this two dates.
Please reply me soon as possible....
Thanks&Regs
Manavalan
Datta KharadPosted Jan 12, 2012, 12:32 AM
Select VPRC_13.*, VPRC_60.* from VPRC_60, VPRC_13 where VPRC_13.key = VPRC_60.key;
Shen HengbinPosted Jan 12, 2012, 12:26 AM
SELECT (your compare columns) FROM tableA EXCEPT SELECT (your compare columns) tableB
union
SELECT (your compare columns) FROM tableB EXCEPT SELECT (your compare columns) tableA
it would list all the records which are diffrence. and if the result is nothing. it appears the two table are all the same.