That is interesting, indeed. I have no idea why the where clause in the second fails. I’m such a log of help! Albert
> On Apr 21, 2018, at 12:45 PM, Claudine Robbins <[email protected]> wrote: > > I’m stumped and probably because I fail to remember some basic rule in RBase. > > Why does: > > sel count(*) fro i_companies whe company_name is null > count (*) > ---------- > 2 > > But: > > R>sel * fro i_companies whe company_name is null > <WARNING> No rows exist or satisfy the specified clause. (2059) > > Can someone set me straight? > > TIA, > > Claudine > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- 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]. For more options, visit https://groups.google.com/d/optout.

