Adding Values.... 1

[CTSQLGUY]

I want to be able to add the results of my query, shown below, together to create a new expression...

----------------------------------------------------

SELECT TOP 1 TableA.F1 AS A, TableB.F1 AS B
FROM TableB CROSS JOIN
TableA
ORDER BY TableA.F1 DESC, TableB.F1 DESC

----------------------------------------------------

I want to be able to take the results of A and B and add them together to create C without creating a new table... any help is MUCH appreciated!

Thanks!

 

[r937]

SELECT TOP 1
TableA.F1 AS A
, TableB.F1 AS B
[red], TableA.F1 + TableB.F1 AS C[/red]
FROM TableB
CROSS
JOIN TableA
ORDER BY TableA.F1 DESC, TableB.F1 DESC


r937.com | rudy.ca

 

[CTSQLGUY]

Thanks a ton! That's PERFECT!