I have tried the above code and get the following error.................. SQL State: 42X04 Error Code: 20000 Message: Column 'PROFIT' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER statement then 'PROFIT" is not in the TABLE
profit is a double variable? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-the-last-column-in-the-newest-record-tp143710p143720.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
