Re: DELETION PROBLEM

From: Darren K. Cockrel <derwoud_at_bellsouth.net>
Date: Tue, 01 Sep 1998 03:21:18 GMT
Message-ID: <OKJG1.114$S66.482097@news1.atl.bellsouth.net>

I beilieve that this will work:
delete from x
where x.field in (select y.field1 from y) Darren

Sreenivas wrote in message <35EB247E.19B93CE5_at_hotmail.com>...
>Hi
>delete x
> where upper(substr(CLLI,1,4)) =
> upper(y.CLLI_NAME)
> /
>
>X AND Y ARE TWO DIFFERENT TABLES.
>
>Can you give the condition like this in delete statement.?
>
>If not possible solution?
>
>Thanx
>Srinivas
>
>:
>
Received on Mon Aug 31 1998 - 22:21:18 CDT