FM equivalent of "where not exist" ?

[Bobbby]

Hi,

I'm sure other newbies have asked this one before so I'm looking for articles or pointers or howtos...

I have two tables : PRODUCTS and SALES.

PRODUCTS is linked to SALES by product_ID

In an FM script, how would I select the products that have no entries in the SALES table ?

How does FM handle joins when there is no join ?

TIA

Bobbby

Edited October 30, 2008 by Guest

[comment]

While in PRODUCTS, you can search the RELATED field SALES::product_ID for * (not empty) and make the request omit the found records. This can be scripted, with the request stored within the Perform Find[] script step.

[Bobbby]

Thanks.

Will give that Bbbblast asap !

[Raybaudi]

BTW: I think that you'll need another table: sale rows

sales.zip