Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Calculated fields in recordset?

Calculated fields in recordset?

Thread began 6/29/2012 2:41 am by gary.brett434358 | Last modified 7/05/2012 9:38 am by gary.brett434358 | 6956 views | 15 replies

6/29/2012 8:41 amJason ByrnesWebAssist

the where clause is using the table tblreferral, this table is not included as part of the FROM or inner join clause.

you cant refer to a table in the where clause that is not used in the from or inner join clause of the query

the From and Inner Join portion of the query tells the database what tables you are looking at the data for.

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.