[SQL] nested select within a DISCTINCT block

2006-09-14 Thread zqzuk
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,

Re: [SQL] nested select within a DISCTINCT block

2006-09-14 Thread Daryl Richter
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,

Re: [SQL] nested select within a DISCTINCT block

2006-09-14 Thread zqzuk
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

Re: [SQL] nested select within a DISCTINCT block

2006-09-14 Thread Niklas Johansson
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