SQL Query to compare two table values?

Jan 11 2012 12:55 AM

i want to know query for sql to compare two table values whether it is greater or equal to for that two values.

My table name is VPRC_60 and VPRC_13

VPRC_60.YYYYMM1>=VPRC_13.YYYY2

my values VPRC_60.YYYYMM=200601 and VPRC_13.YYYY=2005

Pls send me soon as possible

Thanks&Regs

Manavalan

Answers (2)

WHEN-Database-record trigger

How to select one table values greater then another table valuse using sql server with on Example