Hi try this one...! First take a back up of the table T1 and then run this query.
Delete from Table_1 t1 inner join Table2 T2 on T1.Deptno = T2.Deptno where T2.location = "Chicago" regards, Birumanand. --- keyrun_psft <[EMAIL PROTECTED]> wrote: > Hi Gurus, > I need one query which having the following > scenario. > > Table_1(empno,ename,sal,deptno);Table_2(Deptno,Deptnmae,location) > Here i want to delete Table_1 records based on > Table_2 result-- like > if the location='Chicago' > > I need this query in MS-Access format. > > Pleage help me. > Thanks in Advance > Keyrun > > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
