Outer view would work. I use the query wizard to get the syntax correct for me.

Dan Goldberg

From: [email protected] <[email protected]> On Behalf Of jan 
johansen
Sent: Wednesday, December 23, 2020 9:33 AM
To: [email protected]
Subject: [RBASE-L] - Query

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/WC20201223173232.8200C3%40jjcalibrations.com<https://groups.google.com/d/msgid/rbase-l/WC20201223173232.8200C3%40jjcalibrations.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/2E4830CEC16615458329D3D83342F8D0014E77C2D5%40exchange11.

Reply via email to