Morning Dan, browse all from ponds where ((ctxt(pond_id))&(ctxt(farm_section))) not in (select ((ctxt(pond_id))&(ctxt(farm_section))) from feeds)
substitute the column and table names for your ones. Note because the two columns I'm comparing are integers you need to translate them to text. Hope it helps On Tue, Oct 10, 2023 at 8:07 AM Dan Goldberg <[email protected]> wrote: > So, I have two tables and I want to compare what is in table1 that is not > in table2. It is based on two columns(model,partnumber) > > > > I have tried using: > > > > browse all from table1 where model not in (select model from table2) and > partnumber not in (select partnumber from table2) > > > > any blues clues on how to ? > > > > TIA > > > > Dan Goldberg > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/PH0PR19MB5034ED818F10B57F573363A7D4CEA%40PH0PR19MB5034.namprd19.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/PH0PR19MB5034ED818F10B57F573363A7D4CEA%40PH0PR19MB5034.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer> > . > -- Regards Tony -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDATsSQYHCMiqVLjSnMf92aU3cQX-eGB_BSpDRxXcZ%2BsbbQ%40mail.gmail.com.
