Ok so I want to pull back all the information from one table that doesn't have a matching row on the other table.
So for example in sql I would write it like.
select * from inventory_table
where inventory_id not in
(
select inventory_id
from customer_inventory
)
;
I just have no idea how to put this in crystal terms, Like should I click something in link options?
Any help would be much appreciated!
Thanks,
Colman
IP Logged
