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,
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(cancellation_id,
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 details of bookings, for
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