Forum Discussion
Comparing two sets of data
Hi, I am trying to run a query where the I can see all the orders from table 1 that exist in table 2 where the order status does not match. Please see example of tables Table 1 Order No ...
Hi Anonymous ,
Select the Order No column of the two tables to merge.
Then select the required field and expand it.
Finally add a conditional column
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Select the Order No column of the two tables to merge.
Then select the required field and expand it.
Finally add a conditional column
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.