AS/4. 00 - i. Series SQL Update of on table with values from another joined table. I've use an SQL utility on the AS/4. SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this. Only. The. One. IWant'I no longer have access to the SEQUEL tool, and I'm trying to do the same thing with SQL/4. A similar statement in SQL/4.
SQL Commands - Learn about SELECT, DELETE, UPDATE, and WHERE commands. SQL Creating a Table from an Existing Table - Learn SQL (Structured Programming Language) in simple and easy steps starting from basic to advanced concepts with.
UPDATE file. 1 a set a. SELECT COALESCE(b.
FROM file. 2 b WHERE a. Only. The. One. IWant'For each value I'm setting in file 1, I need a whole SQL sub- statement for file 2. That's not so bad for just one value, but I need to update 9 columns in one table with values from another, and if this is the only way, it would be easier to write an RPG program. Does anyone know an easier way to do this with SQL/4. SQL statement for each value you set?
![Sql Table Update From Another Table In Sql Sql Table Update From Another Table In Sql](http://csharpcorner.mindcrackerinc.netdna-cdn.com/UploadFile/rohatash/copy-table-with-data-from-one-database-to-another-in-sql-ser/Images/Default-Database-name-in-query-window-in-Sql-Server.jpg)