Originally Posted by WolfShade
If it's MS-SQL, it should be V.voltage as voltage2
If it's Oracle, it is correct (no "as"). Not sure about MySQL.
I got the impression that it was TSQL- but you raise a good point...
@OP: What DB are you using? SQL2008R2? SQLEXPRESS? MySQL?
What management tool are you using? I think you need to take your query and get it working in your management tool. You design the queries first, then incorporate them into code... not find and error and then try to figure out if it is ASP or SQL or 'other' error; guarantee your SQL then worry about debugging ASP code.