Re: SELECT and LIMIT question

2004-10-13 Thread Jay K
rote: > Why do you think it doesn't work with LIMIT? Do you > want 5 of each? > > Michael > > Jay K wrote: > > > Hi, > > > > I have multiple queries like this: > > > > SELECT col1, col2, col3, col4 FROM table1, table2 > >

Re: SELECT and LIMIT question

2004-10-14 Thread Jay K
Works great. Is the a limit on the size of the query. There are currently 50 queries (may go upto 300 in future) and each has 15 cols (250b each query) which makes the entire query 12kb (250 x 50). Thanks, Jay --- Michael Stassen <[EMAIL PROTECTED]> wrote: > Right. > > (SELECT col1, col2,