Return to FileMaker.com
Best way to compare two fields in script
I have one table with shopnames and another table with prices, products and their originating shopnames (many doublets).
Now I want to show a list of shops that are not in the first table.
i did it with SQL
WHERE shopname_a NOT IN (SELECT DISTINCT shopname_b FROM tbl_b)
Retrieving data ...