On 14 sep 2006, at 23.58, Daryl Richter wrote:
create table booking(booking_id int, customer_id int,
product_package_id
int, details text);
create table cancellation(cancellation_id int , booking_id int, charge
decimal);
insert into booking values( 1, 1, 1, 'Cxl Booking 1' );
insert into boo
Thanks alot!!!
Daryl Richter-2 wrote:
>
> On 9/14/06 1:13 PM, "zqzuk" <[EMAIL PROTECTED]> wrote:
>
>>
>> Hi, here i have a problem with this task...
>>
>> I have a table "cancellation" which stores cancelled bookings and details
>> of
>> charges etc
>> and a table "bookings" which stores d
On 9/14/06 1:13 PM, "zqzuk" <[EMAIL PROTECTED]> wrote:
>
> Hi, here i have a problem with this task...
>
> I have a table "cancellation" which stores cancelled bookings and details of
> charges etc
> and a table "bookings" which stores details of bookings, for example:
>
> cancellation(cancell
Hi, here i have a problem with this task...
I have a table "cancellation" which stores cancelled bookings and details of
charges etc
and a table "bookings" which stores details of bookings, for example:
cancellation(cancellation_id, booking_id, charge)
booking(booking_id, customer_id, produc
On Thu, Sep 14, 2006 at 03:07:35PM +0900, Javanesevn wrote:
> Dear all,
>
> I execute this query on below:
>
> delete from PRODUCT
> where exists (
> select
> product_id, item_id
> from PRODUCT
> where
>research_date < '2006-
Hi, Javanesevn,
Javanesevn wrote:
> I execute this query on below:
>
> delete from PRODUCT
> where exists (
> select
> product_id, item_id
> from PRODUCT
> where
>research_date < '2006-01-01'
> )
> this query deleted all
