How To Write Sql Statements In A Script . Write an excel concatenate function as shown below. An sql select statement retrieves records from a database table according to clauses (for example, from and where) that specify criteria. SQL recipes — Dataiku DSS 9.0 documentation from doc.dataiku.com Start learning sql now » examples in each chapter. Update table_name1 set table_name1.column1 = table_name2.columna table_name1.column2 = table_name2.columnb from table_name1 join table_name2 on table_name1.foreignkey = table_name2.key. Mysql, sql server, ms access, oracle, sybase, informix, postgres, and other database systems.