Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Urgent Help Needed - Newbie Q on a simple SQL Query
Hello all,
I need some help to work out the Flight Numbers of any flights that travel to ALL the same destinations as XX
I have managed to list the Flight Numbers(BELOW) of the flights which travel to ANY of the DESTINATIONS as XX - that was easy ;)
How do I work out in SQL the query for Flight Numbers that travel to ALL the same ones as XX does ??
[ie: If XX travels to A, B ,C - I need to work out which other flights travel to ALL 3(A & B & C) and not just A or B]
Kind Regards
Thomas Ross Received on Fri Apr 26 2002 - 08:06:41 CDT
![]() |
![]() |