Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Self Join - To use a repeat region in recordset

Self Join - To use a repeat region in recordset

Thread began 12/27/2020 5:58 am by msbannister373603 | Last modified 12/30/2020 9:18 am by msbannister373603 | 1814 views | 6 replies

12/29/2020 8:32 amRay BorduinWebAssist

I'm still confused. If you already have oppo1 and oppo2 in the table on a single row, why do you need a join at all?

Can I see what this would look like: SELECT gameID, teamID, opp1, oppo2 FROM games

If I see the database contents before the joins maybe I can understand what you need to get the output you want.

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.