I have the following impex export statement working. However, I would like to add orderstatus columns to the results. How do I list more than one table in the INSERT_UPDATE statement?
INSERT_UPDATE order;pk;extendedorderid;code;creationtime "#% impex.exportItemsFlexibleSearch(""select {o.pk},{o.code}, {o.extendedorderid}, {o.creationtime} from {order as o join orderstatus as s on {o.status}={s.pk}} where {s.code} = 'SUBMITTED'"");"