Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Display data from related tables in results

Display data from related tables in results

Thread began 4/30/2009 11:48 am by phil.evans372967 | Last modified 8/27/2010 12:04 pm by phil.evans372967 | 9533 views | 16 replies

5/01/2009 7:54 amtom92909Beta Tester

Using an INNER JOIN would be good.

"SELECT *
FROM prop_details INNER JOIN prop_images ON prop_images.prop_id = prop_details.prop_id"

Something like that should help I think....

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.