Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Show details with advance recordset

Show details with advance recordset

Thread began 7/02/2011 8:27 am by wbrooks199805 | Last modified 7/10/2011 11:18 am by wbrooks199805 | 4627 views | 26 replies

7/02/2011 8:27 amwbrooks199805

Show details with advance recordset

I have 2 tables. One "members" and the other "naics". I have 6 different items in members (serviceone, servicetwo, servicethree, servicefour, servicefive, servicesix) and trying to call in the naicsTitle from naics. I know how to call in one item from the naics table but when I try 2 it doesn't work.

I know this isn't the answer below in select but the first one will work for naicsTitle but after that I am stuck.

SELECT naicsTitle, serviceone, servicetwo, servicethree, servicefour, servicefive, servicesix
FROM members
JOIN naics ON members.serviceone = naics.naicsNum AND members.servicetwo = naics.naicsNum

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.