On Fri, 10 Aug 2001, Bruce Momjian wrote:
> >
> > select * from env_info,summary,plat_info;
> >
> > Is my statement broken? Is this not legal? Postgres just sits there....
> >
> > My goal is to select everything from multiple tables with one sql
> > statement.
>
> You didn't join the tables. This will join each row to every other row.
> This will take a long time.
Any tips on this syntax? I'll go look at joins right now I guess :-)
-jeremy
--
salad.