"nicks.emails" <nicks(dot)emails(at)ic24(dot)net> writes:
> select l.s # p.ss from LSEG_TBL l, LSEG_TBL1 p;
> when I try to execute this intersection on the tables that are in the
> regression queries the following message is printed to the screen,
I'm confused --- I don't see any table named LSEG_TBL1 in the standard
regression tests. Are you sure you didn't create that one yourself?
I tried
select l.s # p.s from LSEG_TBL l, LSEG_TBL p;
using the table that is there, and it gave me answers (I have no idea
if they're right though ;-)).
regards, tom lane