Skip to Content
0
Former Member
Aug 08, 2016 at 08:46 PM

How to Join Multiple Tables in Impex Export Statement

2257 Views

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'"");"