On Fri, 10 Aug 2001, Jeremy Hansen 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.
Well, without a JOIN or a WHERE clause, this query is going to try create
the raw cartesian product of the two tables. If you have a lot of data in
your tables, this might take a while, because it will return every
possible combination of rows.
Regards,
Jw
--
jlx(at)commandprompt(dot)com
by way of pgsql-general(at)commandprompt(dot)com