Re: Need help with a query

In article <6f9rft$otu_at_bgtnsc02.worldnet.att.net>, gennick_at_worldnet.att.net says...
> On Mon, 23 Mar 1998 16:19:09 -0600, dwarakv_at_hotmail.com
> wrote:
>
> > I have two tables A and B. I need to delete those records from table A
> >which match records in Table B. The description of the two tables are
> >
> > Table A Table B
> >I_id Number E_id Number
> >I_date Date E_date Date
>
> Assuming that ID and DATE are the keys, you could do
> something like this:
>
> delete from table_a
> where exists (
> select * from table_b
> where table_a.l_id = table_b.e_id
> and table_a.l_date = table_b.e_date
> )
>
> Jonathan
>
>

and even if they aren't the complete keys, you could just expand the where clause in the subselect to include all five matching fields.

share and enjoy.

tzad

-- 
"Uncle Tzad's House o' SQL"  -- soon to be a major motion picture.