File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Cleared Part I with 83%
getting a 500 error
Part 2 - Flight x Segment
How do I change the content of the combo box based selction on other combo box.
JPQL help