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
相关阅读
我的EA Server怎么回事?安装好sybase 12.5（sybase站上下的）后怎么没有pub2MySQL on Macusing localized table names in sybase databaseUrgent help!!!How to burn .cpio file to CD?How to read CLOB by sqlplus?very strange problem on getting data from database file [perl]急急急！谁知道SAS软件是哪一年出来的。大型数据库求助安装mysql遇见的问题。小声问: what's content of database design and implementation ?How to load data into Mysql from txt file?关于M$ Access文件的问题Table Merge (SQL Server)请问各位大虾，哪里可以downloand MS Sqlserver 2000的英文版，多谢jdbc to db2 on linux问题generally ppl take oracle certificate for DBA or developer?New SERVER purchaseQuestion to JDBC