Hi,
Without giving more detail than you might want, I have a query that runs
fine, but when trying to make a view from it, I get an error. The error
looks like...
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9000 POS(1) System error: Not yet implemented:SELECT IN
FROM PART OF VIEW.
CREATE VIEW vw_taxauth_work_full AS
SELECT ebflxid, bsicd, levelnum
FROM
(select ebflxid, local1 as taxauth from epayrolltax
...
union select ebflxid, local5 as taxauth from epayrolltax),
taxmap
WHERE TAXAUTH IS NOT NULL
...
AND res = false
UNION
SELECT ebflxid, bsicode, levelnum
FROM
(SELECT ebflxid, state1 AS taxauth FROM epayrolltax
UNION SELECT ebflxid, state2 AS taxauth FROM epayrolltax), states
WHERE taxauth = statecd
...
Maybe I can break it into smaller pieces, but this is nowhere what I need
for the full query as it is...
This seems to happen with every version of SAPDB or MaxDB we have.
Thank you,
Noah Silva
Arkema IS&T - Sr. Programmer Analyst
(215) 419 - 7916
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
