what must be done to final result appear in the order of second statement in each que

lse123 · #1 (**permalink**) 10-20-10, 10:17

Queries of the kind of

SELECT * FROM Products WHERE Product_ID IN (SELECT Product_ID FROM SidesFeaturedList ORDER BY AA)
SELECT * FROM Products WHERE Product_ID IN (SELECT Product_ID FROM ThreeFeaturedList)

what must be done to final result appear in the order of second statement in each query?
or this I say is the default?

it-iss.com · #2 (**permalink**) 10-20-10, 12:38

Hi,

Firstly the order by clause in a subquery is irrelevant and should be removed. What you need to do is to have the ORDER BY statement on the primary query. Using the IN is filtering your rows but you actually need to join the two tables so that you can use the column you want to order by:

Code:

SELECT p.* FROM Products p, SlidesFeaturedList s WHERE p.Product_ID = s.Product_ID
ORDER BY s.AA

r937 · #3 (**permalink**) 10-20-10, 13:14

two minor but important improvements:

Code:

SELECT s.AA
     , p.* 
  FROM Products AS p
INNER
  JOIN SlidesFeaturedList AS s 
    ON s.Product_ID = p.Product_ID
ORDER 
    BY s.AA

Internet Services

Web Development

Digital Marketing

Consumer Tech