Question on SQL Query# Database - 数据库
n*l
1 楼
I generated TableA and TableB in "subqueries" of the SQL statement, say
Table A: Table B:
columnA columnB columnC
Table A: Table B:
columnA columnB columnC
n*l
2 楼
I got the following error message says missing a keyword. The AB in your
code, is it the new table name?
SQL> select A.columna as newa, A.columnb as newb, b.columnc as news
2 into AB
3 from A, B
4 ;
into AB
*
ERROR at line 2:
ORA-00905: missing keyword
So basically this is a cartesian join?
code, is it the new table name?
SQL> select A.columna as newa, A.columnb as newb, b.columnc as news
2 into AB
3 from A, B
4 ;
into AB
*
ERROR at line 2:
ORA-00905: missing keyword
So basically this is a cartesian join?
s*i
3 楼
don't know which DB you use, but try into table AB
【在 n*l 的大作中提到】
: I got the following error message says missing a keyword. The AB in your
: code, is it the new table name?
: SQL> select A.columna as newa, A.columnb as newb, b.columnc as news
: 2 into AB
: 3 from A, B
: 4 ;
: into AB
: *
: ERROR at line 2:
: ORA-00905: missing keyword
相关阅读
还有比ORACLE更难使的数据库吗？请教SQL小心地问问：Oracle DBA 哪本书最好呢？今天惊闻......怎样解决 Index for NULL valuemysql 在两台电脑中倒数据？ (转载)MySQL founder quits Sun(ZZ)Oracle and HP(ZZ)请教dev&test 和 production environment sync的问题网上哪有文章介绍 SQL server 的 TDATA? sql server 面试题 （2）请教 sql server IN vs. OR请教：SQL面试题。Google search finds seafaring solution(ZZ)correlated subqueryWhich design is better?sql面试题2INSERT or UPDATE, which is faster?叹,时也,命也sql server 面试题 （1）