This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

how to write this query ?

meeta gaur
Ranch Hand
Posts: 305
Notepad Tomcat Server Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

id is foreign key for second table,I need aircraft_name,airport_name as a result
for airport_city="mumbai"

Condition is that in search not only searched city's aircraft should
come as well as closest city's aircraft should also come.

i.e closest city of mumbai is pune(based on alternative_base_airport
value of mumbai which is home_base_address of pune)

so when user provide argument airport_city="mumbai"

then result should be like that

What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!