It's not a secret anymore!
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 Make it so: Java DB Connections & Transactions this week in the JDBC 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....
I agree. Here's the link:
subject: SQL Query for Airline Reservation
jQuery in Action, 3rd edition