Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Sub Catagories and recordsets

Sub Catagories and recordsets

Thread began 9/22/2009 7:20 pm by martin317528 | Last modified 9/24/2009 12:03 pm by martin317528 | 1036 views | 4 replies

9/24/2009 10:16 ammartin317528

Result!

Jason, you are a genius!

That works a treat (with a minor change to lines 2 and 3)

FROM mainTabel
INNER JOIN childTable1 ON mainTable.FKColumnForChildTable1 = childTable1.ID
INNER JOIN childTable2 ON mainTable.FKColumnForChildTable2 = childTable2.ID
INNER JOIN childTable3 ON mainTable.FKColumnForChildTable3 = childTable3.ID

Thanks

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.