This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQL Query for Airline Reservation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Query for Airline Reservation" Watch "SQL Query for Airline Reservation" New topic
Author

SQL Query for Airline Reservation

Atul Prabhu
Ranch Hand

Joined: Dec 17, 2002
Posts: 60
In Airline Reservation System, I want to determine the various connectivities between two different cities.
There might be N combinations for the above query.
i.e A-->B-->C-->D
A-->E-->F-->D
A-->E->D
How will I solve this problem in MS-SQL, do we have the facility for recursion with tables.
And one more doubt : What is exactly a leg?
Sayyed JI
Greenhorn

Joined: Dec 17, 2002
Posts: 1
hi!!
Actually....it is a very complex problem...
and typically i know 2 ppl who can solve it...
1. ME
2. Niranjan

I wont help u coz i got more important work to do...
u can ask niranjan... he knows ER diagram very well....
bye!!
P.S. plz be polite to niranjan....
 
Have you checked out Aspose?
 
subject: SQL Query for Airline Reservation
 
It's not a secret anymore!