JET-SQL Error: On Full Left Cross Inner Right Using Exception

[Jeremiah31]

I can't find any references to this error: "On Full Left Cross Inner Right Using Exception" Does anyone know what it means?

I'm trying to incorporate a left Join with inner..


SELECT SSCPGM.WHPMTLDA.TRLR_ID_NO AS Trailer,
SSCPGM.WHPMTLDA.TRLR_VNDR_NAME AS VendorName,
SSCPGM.WHPMTLDA.RELOAD_FLAG AS Reload,
SSCPGM.WHLMTLHE.TRLR_CARR AS Carrier,
SSCPGM.WHLMTLHE.TRLR_MFST AS Manifest,
SSCPGM.WHPMTLDA.TRLR_DEPT AS Dept,
SSCPGM.WHPMTLDA.TRLR_CRTN_QTY2 AS CRNTQty,
SSCPGM.WHPMTLDA.TRLR_GOH_QTY2 AS GOHQty,
SSCPGM.WHPMTLDA.VPP_OTT AS YPPANDOTT,
SSCPGM.WHPMTLDA.TRLR_PO_NO AS PO,
SSCPGM.WHPMTLDA.ADDA11 As ADDA,
SSCPGM.WHPMTLDA.ADMO11 As ADMO,
SSCPGM.WHPMTLDA.ADYR1 As ADYear,
SSCPGM.WHLMTLHE.UNLDD2 As UNLDDA,
SSCPGM.WHPMTLDA.RCVDA6 As INYRDA,
SSCPGM.WHPMTLDA.RCVMO6 As INYRMO,
SSCPGM.WHPMTLDA.RCVYR6 As INYRYear,
SSCPGM.WHLMTLHE.UNLDM2 As UNLDMO,
SSCPGM.WHLMTLHE.UNLDY2 As UNLDYear,
SSCPGM.MPPMPOHA.PO_HEAD_LADDER_MONTH AS LadderMonth,
SSCPGM_MPPMPOHA.PO_HEAD_LADDER_YEAR AS LadderYear



FROM (SSCPGM.WHPMTLDA INNER JOIN SSCPGM.WHLMTLHE ON
(SSCPGM.WHPMTLDA.RCVYR6 = SSCPGM.WHLMTLHE.RCVYR6) AND
(SSCPGM.WHPMTLDA.RCVMO6 = SSCPGM.WHLMTLHE.RCVMO6) AND
(SSCPGM.WHPMTLDA.RCVDA6 = SSCPGM.WHLMTLHE.RCVDA6) AND
(SSCPGM.WHPMTLDA.RCVCY6 = SSCPGM.WHLMTLHE.RCVCY6) AND
(SSCPGM.WHPMTLDA.TRLR_ID_NO = SSCPGM.WHLMTLHE.TRLR_ID_NO) AND
(SSCPGM.WHPMTLDA.RELOAD_FLAG = SSCPGM.WHLMTLHE.RELOAD_FLAG)


LEFT JOIN SSCPGM.MPPMPOHA AS SSCPGM.MPPMPOHA ON
(SSCPGM.WHPMTLDA.TRLR_PO_NO = SSCPGM.MPPMPOHA.PO)


GROUP BY SSCPGM.WHPMTLDA.TRLR_ID_NO,
SSCPGM.WHPMTLDA.TRLR_VNDR_NAME,
SSCPGM.WHPMTLDA.RELOAD_FLAG,
SSCPGM.WHLMTLHE.TRLR_CARR,
SSCPGM.WHLMTLHE.TRLR_MFST,
SSCPGM.WHPMTLDA.TRLR_DEPT,
SSCPGM.WHPMTLDA.TRLR_CRTN_QTY2,
SSCPGM.WHPMTLDA.TRLR_GOH_QTY2,
SSCPGM.WHPMTLDA.VPP_OTT,
SSCPGM.WHPMTLDA.TRLR_PO_NO,
SSCPGM.WHPMTLDA.ADDA11,
SSCPGM.WHPMTLDA.ADMO11,
SSCPGM.WHPMTLDA.ADYR11,
SSCPGM.WHLMTLHE.UNLDD2,
SSCPGM.WHPMTLDA.RCVDA6,
SSCPGM.WHPMTLDA.RCVMO6,
SSCPGM.WHPMTLDA.RCVYR6,
SSCPGM.WHLMTLHE.UNLDM2,
SSCPGM.WHLMTLHE.UNLDY2,
SSCPGM.MPPMPOHA.PO_HEAD_LADDER_MONTH,
SSCPGM.MPPMPOHA.PO_HEAD_LADDER_YEAR

 

[PHV]

Seems not like JetSQL syntax.
PassThru query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Jeremiah31]

Yes it's a PassThru Query

 

[PHV]

So I suggest you post in the target RDBMS forum.

 

[Jeremiah31]

Which area would that forum be found in? I did a find a forum search, nothing populated.

 

[PHV]

Which RDBMS ? Oracle ? SQL Server ? MySQL ? ... ?

 

[Jeremiah31]

Sorry, using Access

 

[PHV]

You really have a table named SSCPGM.WHPMTLDA in Access ?

 

[lespaul]

If it's a pass through query that means you are trying to get data from some OTHER database system, like Oracle, SQL Server, MySQL. If your table is in Access, you can't use a pass through query.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins