creating a query for the Sum of 3 fields from 3 different queries

[lieip]

I get an error message query is too complex when i try to create a query that adds 3 fields from three other queries. What can i do to fix this error?

 

[rac2]

Hello lieip,

What database are you using?
What is the query?

In SQL Server a query like this works just fine.

SELECT @valueFinal = (SELECT MAX(valueOne) FROM tableOne) + (SELECT MAX(valueTwo) FROM tableTwo) + (SELECT MAX(valueThree) FROM tableThree)

You might want to post your question in a database forum instead of the ASP forum since queries are not part of ASP.