Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ibn-al-haytam
Starting Member
5 Posts |
 Posted - 2010-09-30 : 05:42:38
|
| i have got a very big problemeand i want help please i have three tables :pilotes,flights, and airplanes.pilote and flight are joined based on their piloteID,flight and airplanes are joined based on their airplaneID.i want to extract a list of pilote that lives in the same city as airplane with a specific typesorry for inconveniencesthanks for help |
|
|
rohitvishwakarma
Posting Yak Master
232 Posts |
Posted - 2010-09-30 : 06:34:54
|
| can you please post some sample data and relevant columns of your three tables |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-09-30 : 11:42:37
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|
|
a very big probleme