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
> where table1.col1 = table2.col1 and table1.col2 = 1
> ORDER BY col3 desc LIMIT 5
>
> and
>
> SELECT col1, col2, col3, col4 FROM table1, table2
> where table1.col1 = table2.col1 and table1.col2 = 2
> ORDER BY col3 desc LIMIT 5
>
> The only difference is in the WHERE clause table1.col2
> = x.
>
> I would like to have one statement instead of multiple
> statements and though about using IN clause like:
>
> SELECT col1, col2, col3, col4 FROM table1, table2
> where table1.col1 = table2.col1 and table1.col2 IN
> (1,2,3) ORDER BY col3 desc LIMIT 5
>
> It works without LIMIT, but I need to use the LIMIT.
>
> Any help is appreciated.
>
> Thanks in advance,
> Jay
>
>
>
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
>
