Home > Database > Mysql Tutorial > Condition variables in SAP subquery

Condition variables in SAP subquery

WBOY
Release: 2023-09-04 12:37:02
forward
1217 people have browsed it

SAP 子查询中的条件变量

One line answer - subqueries not allowed.

But if you need to handle your scenario then you can do the following:

  • Encapsulate the entire query into a stored procedure, and then use the stored procedure.

  • Create a view. Views are created to process main queries or subqueries.

  • Create a table-level variable and store the final result of the view in it, and then continue to get the value of the table variable in the main query.

The above is the detailed content of Condition variables in SAP subquery. For more information, please follow other related articles on the PHP Chinese website!

source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template