Hi,
can we write single expression rule to get data from multiple table, if it's possible how it can be simple example
like: select orders.orderid, customers.custername from order inner join customers on orders.customerid=customer.customerid
can we write such query in expression rule
Thanks,
Kavya
Discussion posts and replies are publicly visible
Hi there,
Stewart Burchell has already told you the two ways. Another approach can be to query 2 different tables by passing the output of one QE into another as input and then combining the result in a third expression rule. However, I would still prefer creating records and then using record relationships.
Yes, I inferred this was possible, but it's not an easy option and, frankly, why would you opt for this when there are much easier options available to you.
I agree.