Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Function for displaying data from seperate tables in same database.

Function for displaying data from seperate tables in same database.

Thread began 1/04/2010 4:22 am by ijk76319396 | Last modified 1/11/2010 3:44 pm by ijk76319396 | 2204 views | 6 replies

1/04/2010 3:32 pmJason ByrnesWebAssist

Your close, but you have to join the two tables together to get the correct data.

your subscribe table should have a primary key column, the uploads tabel should have a foreign key column that is used to relate the upload top the subscriber. This foreign key column can be used to join the two tables together using an INNER JOIN:
SELECT uploads.*`, subscribe.*
FROM uploads
INNER JOIN subscribe on uploads.<primaryKey> = subscribe.<forignKey>

you will need to substitute the names of your primary and foreign key column in the example above.

See the following for more info on join queries:
sql_join.asp

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.