Jan, How many times have I had those, Duh, moments. Too many to recall. You also have a Merry Christmas.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of jan johansen Sent: Wednesday, December 23, 2020 11:44 AM To: 'Jim Belisle' via RBASE-L <[email protected]> Subject: RE: [RBASE-L] - Query Duh, Thanks Jim. Merry Christmas! Jan From: "'Jim Belisle' via RBASE-L" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Wed, 23 Dec 2020 17:35:11 +0000 Subject: RE: [RBASE-L] - Query BROWSE table1 WHERE common col info NOT IN (SELECT common col info FROM table2) James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of jan johansen Sent: Wednesday, December 23, 2020 11:33 AM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - Query CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Group, Situation. Table 1 and Table 2 are related via a common column. I want to view items in Table 1 that doesn't have any data in Table 2. This should be simple but the syntax escapes me right now. Jan -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F53004A650C67DE5AD62A0DE0%40CY4PR0201MB3394.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F53004A650C67DE5AD62A0DE0%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. ________________________________ -- 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/CY4PR0201MB3394E7339718DAB158C9C273A0DE0%40CY4PR0201MB3394.namprd02.prod.outlook.com.
