Joining and having problems

[KOVMoe]

I have a table that has all of the airports that the applcaition requires. I have another table that stores detail about shipments. The problem is I need to update and pull old information from one server to another. The detail table has origin airports and destination airports on the same row. When I join the origin, everything is great. When i try to join the destination i run into problems. Here is my code:
select a1.locations,x1.apo_sys_nr,z1.apo_sys_nr
from dbo.aser_dtl_data a1
inner join dair0013.dbo.tarxapo x1 on a1.org_ap_code = x1.apo_cd
inner join dair0013.dbo.tarxapo z1 on a1.dtn_ap_code = z1.apo_cd


Thank you,

Moe-King of the Village Idiots.

"When in trouble,
when in doubt;
Run in circles-
SCREAM & SHOUT!!"
Burma Shave

 

[bborissov]

And the problem is?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP