Hi Pradeep,

U can try this

where field name >= '07/01/2008' and dateadd(dd,-1,field name ) < '07/03/2008'

regards,

Balamurugan G

Please avoid posting these sort of misleading questions.

select CategoryID, Quantity, Price

from Customer c, SalesOrderDetail sod

where sod.clientid in (select customerid where pricingplan='X')

works even without customerid in any of the table but...

Hi Raja,

u could use

insert into s1.d1

select * from s2.d2

Chandra...use the import and export Data and select the file u wanted and give the identifier and then the target database where u could give the table name also...