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 | 9532 views | 16 replies

4/30/2009 3:41 pmphil.evans372967

Hi Ray,

Thanks for your reply

I'm not sure what with the first part. Do you mean combine the two queries into one something like this

SELECT prop_details.prop_id, prop_details.prop_type, prop_details.short_desc, prop_details.prop_ref, prop_images.img_thumb, prop_images.prop_ref, prop_images.prop_id
FROM prop_details, prop_images
WHERE prop_images.prop_id=prop_details.prop_id

Thanks

Phil

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.