Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › combining 2 tables using a 3rd table as the link table.

View all replies to this thread

combining 2 tables using a 3rd table as the link table.

Thread began 7/28/2014 6:44 am by Christopher West | Last modified 8/01/2014 11:23 am by Christopher West | 3184 views | 13 replies

7/29/2014 7:57 amJason ByrnesWebAssist

can you give the table structure for all 3 tables, it seams like you aren't doing the join on the correct column.

The join should be done on the linking columns in the featured table

As stated before I was told the only way to solve this is to use sub-queries - but i havent had much expeirence in this.

this tutorial should help with nested recordsets:

http://www.webassist.com/tutorials/Display-nested-recordsets

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.