About DB2SQL

SELECT A.VA_REGION_NAME AS AREA_NAME, A.VA_CIG_TRADEMARK AS CIG_NM, B.DE_BS_CXB AS CXB_REL, A.DE_BS_CXB_PRE AS CXB_PRE
FROM DCDW.FAC_SCC_ZY_REGION_CXB_PRE A
LEFT JOIN DCDW.FAC_SCC_ZY_REGION_CXB B
ON B.VA_CIG_TRADEMARK = A.VA_CIG_TRADEMARK AND A.VA_REGION_CODE = B.REGION_CODE
LEFT JOIN DIM_REGION C
ON A.VA_REGION_CODE = B.REGION_CODE = C.PROV_CODE OR A.VA_REGION_CODE = B.REGION_CODE = C.AREA_CODE

Execute the SQL statement in

DB2, always report an error and find the exception tag "= C" after "CODE = B.REGION_CODE".
check it out, ask God to tell

Oracle

Jan.03,2022

The ON statement after

LEFT JOIN DIM_REGION C is written as follows:
A.VA_REGION_CODE = B.REGION_CODE = C.PROV_CODE

it is grammatically wrong to write this way, and there can only be one equal sign comparison.

I understand that A.VA_REGION_CODE = B.REGION_CODE has already been written when Table An is associated with Table B and should be removed, so the statement after LEFT JOIN DIM_REGION C should be:

LEFT JOIN DIM_REGION C 
ON B.REGION_CODE = C.PROV_CODE OR B.REGION_CODE = C.AREA_CODE

Previous: Do you have any seniors to help simulate the rain effect of Baidu Weather search page with canvas? thank you very much.

Next: Chinese garbled code of jar package compiled by macos

On the Database query Optimization of java programmers in interview
background: 1. I am a java programmer 2. Recently interviewed for a senior development position 3. The previous project mainly used less oracle,mysql, and the companies interviewed basically used mysql s 4. I am weak in the database 5. Recently, I...

Oracle mysql sql java

Feb.27,2021
Oracle database insertion problem of Mybatise
when using Mybatise, I use the following code to operate on the database. No error is reported, and it executes successfully, but the database does not find data @Test public void testInsertUser(){ SqlSession sqlSession = sessionFactory.o...

Insert oracle mybatis java

Feb.28,2021
Tomcat has been running for a period of time, but it has not been reported correctly, but it cannot be accessed.
tomcat can be accessed normally at the beginning, but after a week or two of operation, it cannot be accessed normally, and it does not report an error, but it just cannot be accessed, which is very strange. jdk and tomcat are both 32-bit, is that the r...

Windows oracle tomcat spring java

Mar.01,2021
User amount flow table, how to sub-table?
every amount change of the user is recorded in this table. website users about 100W, now the table is too big, thought of sub-table, how to divide it? Table structure! user id is a 32-bit guid ...

Sub-table sub-table-query oracle

Mar.02,2021
What is stored in the database is the html code, how to blur the contents of the query tag?
what is stored in the database is the html code, which is mainly a piece of div content, including the style, does not contain the body and other tags, and the label is strict in opening and closing. If I want to query the keyword "class " now, if I us...

Oracle sqlserver mysql java php

Mar.03,2021
Oracle database, the structure of the two tables is different. How about inserting the fields in table a + newly assigned fields into table b? Ask for advice, see description for details.
enter the order number on the page to query the data in Table A, extract some of the field values in Table A to the page, and make changes. The other field values remain the same. insert the modified value and the unmodified field into the new table b...

Oracle mysql

Mar.03,2021
How does Entity Framework Core connect to the Oracle database?
how does Entity Framework Core connect to the Oracle database? ...

Oracle entityframework

Mar.04,2021
The usage of as in sql query statement;
is currently self-learning mysql,. When querying, sometimes you need to use as aliases, but after adding as aliases to the following two query statements, why is it incorrect? 1, select cat_id,goods_name,shop_price from goods where shop_price in (sele...

Oracle sql mysql

Mar.05,2021
How PHP handles Spatial data SDO_GEOMETRY objects
PHP oracle GEOLOCPHP I printed the data type of this field, and it turned out to be 108, and Baidu didn t have it for half a day . ...

Oracle php gis

Mar.05,2021
Invalid ORA-01722: number, the field type of both tables is varchar (2)?
when writing insert sql statements with python + cx_oracle, the error message is an invalid ORA-01722: number. The field types of the two tables are the same, and they are executed in PL SQL, and the field that reported the error is found. But after loo...

Sqlserver mysql oracle

Mar.05,2021
An Analysis of the Business scenario of Synchronize
The business scenario is as follows: I provide a ws server A for client B to call. Each call, the client inserts a piece of data into the database tab and then submits it. My server An internally calls another server C, and passes this data to the serve...

Webservice oracle sql

Mar.05,2021
Date-time format conversion of Python connecting to Oracle database through cx_Oracle?
1. Process: Python looks up the data in the table through cx_Oracle and inserts the data into another table. 2. The type of date and time stored in both tables is of type Date. 3. The time field I took from the query table prints out that the type i...

Python oracle sqlserver

Mar.06,2021
My side of the project code is UTF-8, nearly 2 days before the launch of the customer said that the assigned database is GBK, and the database code can not be changed, is there any solution?
big head. ...

Oracle spring c cPP java

Mar.06,2021
Oracle beginner problem, number of connections
what is the relationship between the number of oracle, connections, session sessions and users? assuming that the default number of connections installed is 150, is it true that the total number of connections for all users cannot be greater than 150? Or...

Oracle

Mar.06,2021
Error results after using ORDER BY on emp datasheet
conn c-sharp-sharpscott tiger SELECT * FROM emp ORDER BY hiredate; output the following result: if you do not specify whether the sort is ascending or descending, it should be sorted in ascending or descending order, but you can see that the data is...

Oracle

Mar.07,2021
Perform a second screening from the result set
as shown in the figure, this association query is different in that it is associated with the same table indicates that table_test requirement: first query the result set of the field whose reply_type is 0, and then use the reply_id of the resul...

Nosql oracle sql mysql

Mar.07,2021
Multiple tables query the last 100 pieces of data?
how do I query the last 100 pieces of data in multiple tables in the ORACLE database? For example, the two tables of An and B have a time field, and the last 100 items of data in tables An and B are not the last 100 items in An and B. ...

Oracle sql

Mar.07,2021
The problem of oracle limiting the number of user connections
enable limit configuration alter system set resource_limit=true; create a connection number role named sess number of create profile sess limit sessions_per_user; assign to the user alter user username profile sess; when the maximum number of con...

Oracle

Mar.07,2021
What type is used in golang to receive the sys_refcursor returned by Oracle stored procedures?
Code: stmt, err := db.Prepare("begin TestPro(:1,:2,:3);end;") if err != nil { return "",err } defer stmt.Close() var mail string = "1" var pwd string = "2" var op_re_list string var result sql.Result result,e...

Oracle golang

Mar.07,2021
How do I update the value of the same field in multiple tables?
problem description orcaleABCAPHONEBPHONECPHONE: A B C ID PHONE ID PHONE ID PHONE a1 11111 b1 11111 c1 11111 a1 22222 b2 33333 c2 11111 now I want to change the PHONE=11111 in ...

Java mybatis oracle

Mar.09,2021