By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,964 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,964 IT Pros & Developers. It's quick & easy.

please guys help me to get this query

P: 1
Hi guys

I have 4 tables which are (flight, model, airplane, pilot)

Flight: fid, pid, aid, plannedDeparture, actualDeparture, passengerCount, destination
Model: mid, name, usefulLoad, pilotCount
Airplane: aid, mid, oid, hid, dateAqu
Pilot: pid, hireDate

and I need to generate a report (query) for overloaded flights. Assuming the following:
- the passenger/pilot weight is 160 lb on average;
Dec 4 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.