Select (t1) a + t2. B + t3. C) ABC
The from
T1, t2, t3,
Where
Abc> 0
The t1 - t3 for three tables in the Oracle, a, b, c is the column three tables, prompt ABC identifier is invalid, rookie, please more guidance

CodePudding user response:

Where a t1. A + t2. B + t3. C & gt; 0

Don't need a table?

Look not to understand the SQL

CodePudding user response:

reference 1st floor yaiger response:

where t1. A + t2. B + t3. C & gt; 0

Don't need a table?

Look not to understand the SQL

It looks like, should be the original poster is thinking about the alias for conditions directly with,

PS: this doesn't work, the select list, and where are the two the same level of statements, alias column (or columns), can be used in order by,

CodePudding user response:

Can also choose to set a layer to use

 select * from (
Select (t1) a + t2. B + t3. C) ABC 
The from 
T1, t2, t3) 
Where 
Abc> 0 

PS: the where t1. A + t2. B + t3. C & gt; 0 is not equal join

CodePudding user response:

What is ABC, a, b, c three fields, or a field in ABC, if the three fields, written as there is a problem, if you need to get the product of three fields, it should be a * b * c,

CodePudding user response:

ABC is what ah

CodePudding user response:

To add a nested, and can't identify

CodePudding user response:

Your definition of ABC in this layer in the table t no, need to set a layer of the query results as a new table, doing conditions, refer to the third floor