CodingForums.com - View Single Post

Old Pedant · 11-09-2012, 08:52 PM

Code:

SELECT U.views, U.fromTable
FROM ( 
    SELECT views, 'table1' AS fromTable FROM table1 
    UNION 
    SELECT views, 'table2' FROM table2 
) AS U
ORDER BY views DESC
LIMIT 3

11-09-2012, 08:52 PM	PM User \| #5
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,200 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	Code: SELECT U.views, U.fromTable FROM ( SELECT views, 'table1' AS fromTable FROM table1 UNION SELECT views, 'table2' FROM table2 ) AS U ORDER BY views DESC LIMIT 3 __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.