Re: [SQL] save me from an unconstrained join

2005-03-30 Thread Richard Huxton
Robert Treat wrote: It actually does what I want... but it offends my database sensibilities... :-) Heres the basics of the tables involved: CREATE TABLE bds_filesize ( bds_filesize_id serial name text NOT NULL, byte_limit integer NOT NULL, slots integer NOT NULL ); CREATE TABLE sof

[SQL] save me from an unconstrained join

2005-03-30 Thread Robert Treat
It actually does what I want... but it offends my database sensibilities... :-) Heres the basics of the tables involved: CREATE TABLE bds_filesize ( bds_filesize_id serial name text NOT NULL, byte_limit integer NOT NULL, slots integer NOT NULL ); CREATE TABLE software ( sof