Bobbby Posted October 30, 2008 Share Posted October 30, 2008 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted October 30, 2008 Share Posted October 30, 2008 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. Link to comment Share on other sites More sharing options...
Bobbby Posted October 30, 2008 Author Share Posted October 30, 2008 Thanks. Will give that Bbbblast asap ! Link to comment Share on other sites More sharing options...
Raybaudi Posted October 30, 2008 Share Posted October 30, 2008 BTW: I think that you'll need another table: sale rows sales.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5795 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now