Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Advanced recordset question

View all replies to this thread

Advanced recordset question

Thread began 9/06/2016 7:43 pm by EmmaMorris | Last modified 9/07/2016 11:12 am by EmmaMorris | 818 views | 1 replies

9/07/2016 11:11 amRay BorduinWebAssist

SELECT eventtbl.*, performertbl.firstname, weekdaytbl.weekday, performer2.firstname AS perf2firstname
FROM eventtbl INNER JOIN performertbl ON eventtbl.perfID = performertbl.perfID LEFT OUTER JOIN performertbl AS performer2 ON eventtbl.perf2ID = performer2.perfID INNER JOIN weekdaytbl ON eventtbl.weekdayID = weekdaytbl.weekdayID
ORDER BY eventtbl.`date` LIMIT 50

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.