You will need to modify the SQL To use an INNER JOIN like you have tried.
You say the SQL You are using produces an error, but dont specify what the error is.
Can you let us know what the error message is?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.