We are using latest version of Maxdb7.5.0.8.
In our application we are using view with following
outer joins,
CREATE VIEW TEST_PURGE_CLAIM
AS
SELECT TEST_PLAYER.PLAYER_OID AS PLAYER_OID,
MAX(TEST_PLAYER.MODIFIED_DATETIME) AS PLAYER_MD,
MAX(TEST_CLAIMANT.MODIFIED_DATETIME) AS CLAIMANT_MD,
MAX(TEST_CLAIM.MODIFIED_DATETIME) AS CLAIM_MD,
MAX(TEST_CLAIM_TAX.MODIFIED_DATETIME) AS CLAIM_TAX_MD,
MAX(TEST_CLAIM_REASON.MODIFIED_DATETIME) AS
CLAIM_REASON_MD,
MAX(TEST_PAYMENT.MODIFIED_DATETIME) AS PAYMENT_MD,
MAX(TEST_TICKET.MODIFIED_DATETIME) AS TICKET_MD,
MAX(TEST_TAX_ADJUSTMENT.MODIFIED_DATETIME) AS
TAX_ADJ_MD,
MAX(TEST_COMMENT.MODIFIED_DATETIME) AS COMMENT_MD
FROM
TEST_PLAYER LEFT OUTER JOIN TEST_CLAIMANT ON
TEST_CLAIMANT.PLAYER_OID = TEST_PLAYER.PLAYER_OID
LEFT OUTER JOIN TEST_CLAIM ON TEST_CLAIM.CLAIM_OID =
TEST_CLAIMANT.CLAIM_OID
LEFT OUTER JOIN TEST_CLAIM_TAX ON
TEST_CLAIM_TAX.CLAIMANT_OID =
TEST_CLAIMANT.CLAIMANT_OID
LEFT OUTER JOIN TEST_CLAIM_REASON ON
TEST_CLAIM_REASON.CLAIM_OID =
TEST_CLAIM.CLAIM_OID
LEFT OUTER JOIN TEST_TICKET ON TEST_TICKET.CLAIM_OID
=
TEST_CLAIM.CLAIM_OID
LEFT OUTER JOIN TEST_TAX_ADJUSTMENT ON
TEST_TAX_ADJUSTMENT.CLAIMANT_OID
= TEST_CLAIMANT.CLAIMANT_OID
LEFT OUTER JOIN TEST_PAYMENT ON
TEST_PAYMENT.PAYMENT_OID =
TEST_TAX_ADJUSTMENT.PAYMENT_OID
LEFT OUTER JOIN TEST_COMMENT ON
TEST_COMMENT.OWNING_OID =
TEST_CLAIMANT.CLAIM_OID OR TEST_COMMENT.OWNING_OID =
TEST_CLAIM.CLAIM_OID OR
TEST_COMMENT.OWNING_OID =
TEST_CLAIM_TAX.CLAIMANT_OID OR
TEST_COMMENT.OWNING_OID = TEST_TICKET.CLAIM_OID OR
TEST_COMMENT.OWNING_OID =
TEST_TAX_ADJUSTMENT.CLAIMANT_OID
GROUP BY TEST_PLAYER.PLAYER_OID
It seems LEFT OUTER JOIN with OR is not working,
instead of OR just for testing if we replace by AND it
works.
Is it a bug. Or some thing we are missing, Could any
one please let us know what is the correct syntax of
it.
LEFT OUTER JOIN TEST_COMMENT ON
TEST_COMMENT.OWNING_OID =
TEST_CLAIMANT.CLAIM_OID OR TEST_COMMENT.OWNING_OID =
TEST_CLAIM.CLAIM_OID OR
TEST_COMMENT.OWNING_OID =
TEST_CLAIM_TAX.CLAIMANT_OID OR TEST_COMMENT.OWNING_OID
= TEST_TICKET.CLAIM_OID OR
TEST_COMMENT.OWNING_OID =
TEST_TAX_ADJUSTMENT.CLAIMANT_OID
Exception what we get is General error;-7068 POS(1)
Outer join not allowed in this context.
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25�
http://photos.yahoo.com/ph/print_splash
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
