[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, product_pa

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 &

[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, produc