Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › using a linked table

using a linked table

Thread began 4/19/2010 10:44 am by mr hankey | Last modified 4/20/2010 8:17 am by mr hankey | 2216 views | 4 replies

4/20/2010 3:34 amCraigRBeta Tester

in union queries, the data type must be the same.

if the field names are different, the query will use the field name of the first table, unless you give it an alias.

a view using union query is a better option than a temporary table, as the data will always be up to date.

i would tend to go for this approach unless you wanted to create a 'snapshot'

take a look at this link for some background...

sql_union.asp

if you want a bit of help on syntax, let me know.

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.