Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
soroush
Starting Member
2 Posts |
 Posted - 2010-05-22 : 12:08:15
|
| I have a charter table containing : charter_nbr (numeric-pk), ...a charter_leg table containing : charter_nbr(numeric), cl_leg_nbr(nemeric-pk), cl_etd(date), cl_atd(date),...each charter flight may have more than one leg. and each leg has ETD(estimated date+time departure) and a ATD (actual date+time departure)here is the question:I need to desplay the charter_nbr of the charters that ALL of its legs have the same ETD and ATD. meaning that any charter_nbr that ALL of its legs have this condition will be listed.please notic: I need 1 condition for ALL the legs of a charter to display the number of that chartercan anybody help please? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-22 : 13:58:26
|
It would be nice to have some sample data and wanted output in relation to the sample data.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
soroush
Starting Member
2 Posts |
Posted - 2010-05-23 : 02:19:43
|
quote:
Originally posted by webfred
It would be nice to have some sample data and wanted output in relation to the sample data.
No, you're never too old to Yak'n'Roll if you're too young to die.
Here are the full details of the tables: and the exatc question is:Which charters have been able to depart at the time estimated for all legs of its flight? Include in the output the charter number, pilot’s name and the client’s name. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-23 : 06:19:13
|
quote:
Originally posted by webfred
It would be nice to have some sample data and wanted output in relation to the sample data.
No, you're never too old to Yak'n'Roll if you're too young to die.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
setting conditions...Helpppp!