Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Sql Code and show utility

Sql Code and show utility

Thread began 7/15/2013 5:17 pm by Jon Cunningham | Last modified 7/18/2013 12:23 pm by Jon Cunningham | 1607 views | 26 replies

7/17/2013 2:54 pmJason ByrnesWebAssist

1) That is a not strictly a join query

2) there is no relationship created between the orders and users tables.

your orders table should store the User ID. Instead of using the users.userID column in the where clause, use the orders.userID (or whatever the column is named in your orders table.

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.