Try this one, it will give you desired results.
brow * from table1 where (model+partnumber) not in (select (model+partnumber)
from table2)
use CTXT() function for the non text column / field.
Regards
Rehan Wyne
On Tuesday, October 10, 2023 at 03:07:59 AM GMT+5, Dan Goldberg
<[email protected]> wrote:
<!--#yiv0923079530 filtered {}#yiv0923079530 filtered {}#yiv0923079530
p.yiv0923079530MsoNormal, #yiv0923079530 li.yiv0923079530MsoNormal,
#yiv0923079530 div.yiv0923079530MsoNormal
{margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv0923079530
span.yiv0923079530EmailStyle17 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv0923079530 .yiv0923079530MsoChpDefault
{font-family:"Calibri", sans-serif;}#yiv0923079530 filtered {}#yiv0923079530
div.yiv0923079530WordSection1 {}-->
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.
--
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/1293105074.4244220.1696921944467%40mail.yahoo.com.
