MySQL Forums
Forum List  »  Newbie

Re: achievable with the means of SQL?
Posted by: laptop alias
Date: January 12, 2008 02:24PM

SELECT t1.display_id,t1.fs_path,t2.fs_path
FROM playlist_items t1
LEFT JOIN playlist_items t2 ON t1.display_id+1 = t2.display_id
WHERE t1.list_id=123 AND t1.display_id>=12

Options: ReplyQuote

Written By
Re: achievable with the means of SQL?
January 12, 2008 02:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.