problems about database class

[eluser]datactrl[/eluser]
I make a space between ')' and 'as' and the problem is the same. I don't think it's a problem of SQL. Because I copy the exact SQL onto pgAdmin to execute it and it works. And I have database debug on. So if there is an error from database I should catch it. I believe it's a problem from CI database class. When the error happened, it also rollback my deleted records which have been committed as I said I have to delete some detail records before I do the 'COPY' test.