Register / Login
JDBC and Relational Databases
how to write this query ?
posted 2 years ago
cars_aircraft table id aircraft_name home_base_address alternate_base_airport 1 MIG 20 77 80 2 MIG 30 80 77 cars_airport table id airport_city airport_name 1 mumbai CST 2 pune PIA
id is foreign key for second table,I need aircraft_name,airport_name as a result
Condition is that in search not only searched city's aircraft
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
airport_name aircraft_name CST MIG20 PIA MIG30
My one regret in life is that I am not someone else.
- Woody Allen
Hibernate JPQL/HQL: aggregate functions show results of wrong table/entity joined twice
JTable not adding to JScrollPane...WHY ?
could be only joke...
struts2.0 application issues
Progress GIF Just Displays but No Animation