View Single Post
  #1  
Old May 18th, 2010, 05:42 PM posted to microsoft.public.access.queries
gchichester
external usenet poster
 
Posts: 3
Default No data returned from query

I can't seem to figure out why this query will not return any data.

SELECT AsiaContracts.AsiaContractShipper, AsiaContracts.AsiaContractShipLine,
AsiaContracts.AsiaContractNumber, OceanFreightRate.OceanFreigthRateOriginPort,
OceanFreightRate.OceanFreightRateDischargePort, OceanFreightRate.
OceanFreightCharge, OceanFreightRate.OceanFreightAdditionalFees,
EuropeContracts.EuropeContractShipLine, EuropeContracts.EuropeContractShipper

FROM OceanFreightRate INNER JOIN (EuropeContracts INNER JOIN (AsiaContracts
INNER JOIN ContractJunction ON AsiaContracts.AsiaContractID =
ContractJunction.AsiaContractID) ON EuropeContracts.EuropeContractID =
ContractJunction.EuropeContractID) ON OceanFreightRate.OceanFreightRateID =
ContractJunction.OceanFreightRateID
ORDER BY OceanFreightRate.OceanFreightRateDischargePort;

I also posted a screenshot of the design view if anyone needs it.
http://advenet.com/photos/cache/1000...sQuery.jpg.jpg


Thanks any and all suggestions
gchichester