Skip to Content
0
Former Member
Jun 25, 2015 at 12:54 PM

Export all orders where Address Streetname contains

163 Views

I would like to export all orders where the delivery address street name contains GURNSEY or JERSEY. I am having problems trying to link the order to an address, the following query does not reflect what is in HMC

SELECT {Order:code}, {Order:user}, {Address:owner}, {Address:streetName} FROM {Order LEFT JOIN Address ON {Order:user} = {Address:pk} }

Can you help?

Thanks