Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Suleman007
- Order by date
-
Simple Join Problem
Indeed it worked !!!! I changed it a bit, but ur idea really clicked. SELECT A.Prov_ID, P.Name, A.Flight_ID, F.Name, T.Name FROM Provider P, Flight_Detail A, Airport_Detail F, Airport_Detail T WHERE A.Prov_ID = P.Prov_ID AND A.From_Airport_ID = F.Airport_ID AND A.To_Airport_ID = T.Airport_ID...- Suleman007
- Post #3
- Forum: ANSI_SQL
-
Simple Join Problem
Hi, I need a little help regarding a simple SQL query problem. I have a table (Airport_Detail), which has information abt the airports: Airport_ID: Name: Code: etc.. Now I have another table Flight_Detail, which has the following fields: Flight_ID: From_Airport_ID: (FK from Airport_Detail...- Suleman007
- Thread
- Replies: 3
- Forum: ANSI_SQL
