[SQL] nested select within a DISTINCT block

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,

[SQL] nested select within a DISCTINCT block

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

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