468,483 Members | 2,739 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,483 developers. It's quick & easy.

please guys help me to get this query

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
0 751

Post your reply

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

Similar topics

21 posts views Thread by Jenski182 | last post: by
7 posts views Thread by Alan Bashy | last post: by
4 posts views Thread by technobob | last post: by
1 post views Thread by lenygold via DBMonster.com | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.