help Query modification ...... last entry
hi friends .....
i'm web designer ... my first days in MySQl . so please help me guys ....
i have this sql sentences " thanks russell" ....
select a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails, count(b.dlid) as numReplies,a.dlNew,b.replys ,replyDate
from topics a LEFT JOIN replys b On b.dlid = a.dlid WHERE a.dlState=1 group by a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails order by a.dldate desc
it's gives me the first reply and first replyDate but i want select the last reply and date .....
so please help me
my all regards
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)