File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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....
 
I agree. Here's the link: http://aspose.com/file-tools
 
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