Need help with a query
From: <dwarakv_at_hotmail.com>
Date: 1998/03/23
Message-ID: <6f6n09$hv$1_at_nnrp1.dejanews.com>#1/1
Date: 1998/03/23
Message-ID: <6f6n09$hv$1_at_nnrp1.dejanews.com>#1/1
Hi,
[Quoted] [Quoted] I have two tables A and B. I need to delete those records from table A [Quoted] 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 I_code Varchar2(20) E_code Varchar2(20) I_start_time Date E_start_time Date I_stop_time Date E_stop_time Date I_time Number I_a_flag Varchar2(1) I_p_flag Char(1)
e.g.,
Table A contains
8741 22-MAR-98 Open 22-MAR-98 22-MAR-98 .98333333 N Y 8741 22-MAR-98 Lunch 22-MAR-98 22-MAR-98 .98333333 N Y 7864 21-MAR-98 Open 21-MAR-98 21-MAR-98 .98333333 N Y 7864 21-MAR-98 Lunch 21-MAR-98 21-MAR-98 .98333333 N Y
and table B contains
8741 22-MAR-98 Open 22-MAR-98 22-MAR-98 7864 21-MAR-98 Lunch 21-MAR-98 21-MAR-98
In this e.g., I would like to delete the first and the last record in table A. The start_time and the stop_time hold the time along with the dates.Can someone help me with a query for this.
Thanks,
Dwarak
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 23 1998 - 00:00:00 CET