Is it possible to link a 'field' to a 'table reference'

I'm looking to use a 'field' to select a customer in a 'table reference'.  I have tried this code however it dose not work for me.

select Customer where Customer.Email = WooCommerce_Customer_email [code added to 'trigger after update' in WooCommerce_Customer_email]

I should say the reason im doing this is because I am trying to intergrate WooCommerce into Ninox using Integromat and this seems to be the only way of linking the customer name to the order in Ninox.  

Thanks

Jon