Re: Best method to SELECT TOP n TO m of a table

> Could you please post that more complicated query?

The more complicated query just has lots of WHERE qualifiers...

SELECT * FROM tblOne WHERE id IN

    (SELECT TOP 3 id FROM tblTwo WHERE

        id NOT IN (SELECT TOP 5 id FROM tblTwo WHERE
                                        fieldA = 'value' AND
                                        fieldB = 'value' AND
                                        (fieldC = 'value' OR fieldD =
'value')
                        ORDER BY id) AND
        fieldA = 'value' AND
        fieldB = 'value' AND
        (fieldC = 'value' OR fieldD = 'value')

    ORDER BY id)

    AND (flags = 'A' OR flags = 'B')

Something like that!

Cheers :o) Received on Tue Nov 04 2003 - 19:19:04 CET