nested select

[guitardave78]

Can anyone show me how i can do this

SELECT * , (
SELECT pic_path
FROM tbl_newspics
WHERE tbl_newspics.pic_newsid = tbl_news.news_id
LIMIT 1 ) AS pic
FROM tbl_news
WHERE news_publish =1
ORDER BY news_added DESC
LIMIT 5

Basically I have a news table and a pictures table. i want to be able to link them but only have the first picture joined with the news

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[r937]

SELECT N.news_id
     , N.news_added
     , N.other_columns
     , P.pic_path
  FROM tbl_news as N
INNER
  JOIN tbl_newspics as P
    ON P.pic_newsid = N.news_id  
   AND P.somecolumn =
       ( select MIN(somecolumn)
           from tbl_newspics
          where pic_newsid = N.news_id )
 WHERE N.news_publish =1
ORDER  
    BY N.news_added DESC 
LIMIT 5

use LEFT OUTER JOIN instead of INNER JOIN, if it is possible to have a news without a pic

r937.com | rudy.ca