sub query

[Nasser Jun]

hi all member
how you doing ? i hope fine and happy

dear member i want you help me if you don't mind with SQL command which i tried to make it but i can't

this command reading from one table but different Fields

here is the example

THIS IS MS ACCESS DATABASE
*******************************************
Airline DEST *. OUT PAX * ORIGIN * IN PAX*
BA * CAI * 90 * BAH * 70 *
BA * BAH * 85 * CAI * 50 *
KLM * BAH * 300 * CAI * 70 *
KLM * DAM * 35 * BAH * 35 *
AF * DAM * 35 * CAI * 35 *
AF * BAH * 74 * DAM * 74 *
******************************************

NOW IF I'M YOUR BOSS AND I ASKED YOU TO GIVE THE MOVEMENT RECOED FOR BA,
KLM,AF


IT HAS TO BE LIKED THIS


REPORT
*****************************
AIRLINE *STATION *IN PAX *OUT PAX
BA * CAI *50 * 90
BA * BAH *70 * 85
KLM * BAH *35 * 300
KLM * DAM * 0 * 35
KLM * CAI *70 * 0
AF * DAM *74 * 35
AF * CAI *35 * 0
AF * BAH * 0 * 74
*****************************


NOW BEST REGARD AND THANKX IN ADVANCE