I am trying to get the number of records that exist in 1 tables that do not exist in another table. Looking online, I saw an example of a SELECT....WHERE NOT EXISTS.
I have a two questions: 1) Does RR handle the scenario below? For some reason I am getting a error around the "not exists (select * from" when I try to run this. 2) Is there a better way to do this? put revQueryDatabase (gConID, "SELECT Brand_URL, Product_URL, Product_Name, Product_UOM, Product_Retail, Product_Price, Product_Image, Product_Description, from products where not exists (select * from z-products where brand_url = z_brand_url and brand_name = z_brand_name and product_url = z_product_url and product_name = z_product_name and product_uom = z_product_uom)") into tNotExists put revNumberofRecords(tNotExists) into vRecNo Thanks for any help! Warren _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
