problem with my insert query [message #440195] |
Thu, 21 January 2010 09:25 |
pyscho
Messages: 134 Registered: December 2009
|
Senior Member |
|
|
INSERT INTO INTEGRATION.VALN_CHANGES (CASH_BAL_ID)
VALUES (SELECT ACCOUNT_ID || '~' || TXN_CCY
FROM INTEGRATION.CASH_TRANS
GROUP BY ACCOUNT_ID || '~' || TXN_CCY);
it gives a 'missing expression' in the SELECT bit, any ideas guys?
SELECT ACCOUNT_ID || '~' || TXN_CCY
FROM INTEGRATION.CASH_TRANS
GROUP BY ACCOUNT_ID || '~' || TXN_CCY
that just gives me a list of all possible distinct accountid/ccy combination id's - and i just want to insert them into my valn_changes table
|
|
|
|
|
|
|
|