MySQL Forums
Forum List  »  Microsoft Access

sub query
Posted by: Nasser Jun
Date: August 30, 2005 06:56AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
sub query
2314
August 30, 2005 06:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.