File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Query for Airline Reservation" Watch "SQL Query for Airline Reservation" New topic

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
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

Joined: Dec 17, 2002
Posts: 1
hi!! 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....
P.S. plz be polite to niranjan....
subject: SQL Query for Airline Reservation
It's not a secret anymore!