CodingForums.com - View Single Post

Old Pedant · 01-20-2013, 05:44 AM

For example:

Code:

SELECT P2.title AS page_title, pac2_notifications.* 
FROM pac2_notifications 
LEFT JOIN (
    SELECT DISTINCT title FROM pac2_titles 
    WHERE uri = '/demo.php' ) AS P2
ON pac2_notifications.what = P2.title
WHERE what = '/demo.php' AND email != 'hehe@aol.com'

01-20-2013, 05:44 AM	PM User \| #5
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,578 Thanks: 62 Thanked 4,063 Times in 4,032 Posts	For example: Code: SELECT P2.title AS page_title, pac2_notifications.* FROM pac2_notifications LEFT JOIN ( SELECT DISTINCT title FROM pac2_titles WHERE uri = '/demo.php' ) AS P2 ON pac2_notifications.what = P2.title WHERE what = '/demo.php' AND email != 'hehe@aol.com' __________________ 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.