急求

[寂寞很巴黎]

请用一个SQL语句获取如下内容:
OriginFile.SOURCE,
OriginFile.OriginFileName,
MyProcess.Receiver,
MyFile.fenlei,
MyFile.Filename
条件是OriginFile.Airline = 'UA'

[寂寞很巴黎]

补充！！
1.SQL语句：
OriginFile(ID,Source,OriginFileName,Airline)
MyFile(ID,fenlei,Filename,Airline
MyProcess(ID,Receiver,OriginID,FileID)
以上三个表的关系是：
MyProcess中的两个字段,OriginID对应OriginFile的ID,FileID对应MyFile中的ID

[打一壶酱油]

接分

select 
OriginFile.SOURCE,
OriginFile.OriginFileName,
MyProcess.Receiver,
MyFile.fenlei,
MyFile.Filename
from MyProcess,OriginFile,MyFile
where MyProcess.OriginID = OriginFile.ID
and   MyProcess.FileID   = MyFile.ID
and   OriginFile.Airline = 'UA'

[--小F--]

select
   a.Source,a.OriginFileName,c.Receiver,b.fenlei,b.Filename
from
   OriginFile a,MyProcess b,MyFile c
where
   a.id=b.OriginID
and
   b.id=c.id
and
   a.Airline = 'UA'