I am connecting to a oracle database.
There is a table called order_A which has a column order_number
There is another table called order_B which also has an order number
But I want to display orders from order_A and exclude orders from order_B.
Can this be done via the data source dragging and dropping of tables.
So bring back everything in order_A and exclude everything from B.
You can use left join or right join in order to do this, depends on where the "order_A" is at.
hope this helps