SQL语句绑定结果详细绑定

Question

我有以下查询：

select s.ST_SAMPLE_ID, s.st_cn_no as CNNumber,
s.st_smptyp as SampleType,
s.st_wasgrp as WasteCode,
s.st_wascod as WasteCategory,
s.st_received_dt as ReceivedDate,
s.st_wastyp_name as WasteType,
s.st_status as SampleStatus,
s.st_dispose_ind as DisposalStatus,
s.st_container as SampleContainer,
s.st_smppnt as SamplePoint,
s.st_nature as SampleNature,
c.scm_name as Color,cm_client_name 
from sample_txn s,sample_color_mstr c,client_mstr cm  
where s.st_color=scm_auto_no (+) and st_client_id=cm_client_id 
and st_year='13' and s.st_lab_id='R'and to_char(s.st_received_dt, 'MON') = 'FEB'

有第二个查询

select TC.CM_COMPO_NAME as "COMPONENT",CM_SYMBOL as SYM,
CT_UNIT_Name as UOM,CT_METHOD_NAME as "METHOD",
ct_det_status as "REP. LIMITS",
  ct_ts_status as "TEST SPEC.", c.ct_due_dt as "DUE DATE",
  ct_result as "RESULT",ct_rep as "REP",ct_version as "VER",
FROM COMPONENT_TXN C,CODES_MSTR CM, SAMPLE_TXN S, 
  COMPONENT_MSTR TC,  INSTRUMENT_MSTR I 

每个结果：

查询1和2的结果对不起，由于声誉较小，无法插入图像，而只是链接

我想将查询1和2绑定到一个查询中，因此可以选择如下所示的所有值，如下所示：

系统显示对不起，由于声誉较少，无法插入图像，只是链接

我已经尝试将这些查询结合在一起

select s.ST_SAMPLE_ID, s.st_cn_no as CNNumber,
s.st_smptyp as SampleType,
s.st_wasgrp as WasteCode,
s.st_wascod as WasteCategory,
s.st_received_dt as ReceivedDate,
s.st_wastyp_name as WasteType,
s.st_status as SampleStatus,
s.st_dispose_ind as DisposalStatus,
s.st_container as SampleContainer,
s.st_smppnt as SamplePoint,
s.st_nature as SampleNature,
c.scm_name as Color,cm_client_name 
TC.CM_COMPO_NAME as "COMPONENT",CM_SYMBOL as SYM,
CT_UNIT_Name as UOM,CT_METHOD_NAME as "METHOD",
ct_det_status as "REP. LIMITS",
  ct_ts_status as "TEST SPEC.", o.ct_due_dt as "DUE DATE",
  ct_result as "RESULT",ct_rep as "REP",ct_version as "VER"
from sample_txn s,sample_color_mstr c,client_mstr cm, component_txn o,codes_master cm,
component_mstr tc, instrument_mstr i
where s.st_color=scm_auto_no (+) and st_client_id=cm_client_id 
and st_year='13' and s.st_lab_id='R'and to_char(s.st_received_dt, 'MON') = 'FEB'

，但是出现错误

Error at Command Line:13 Column:2
Error report:
SQL Error: ORA-00923: FROM keyword not found where expected
00923. 00000 -  "FROM keyword not found where expected"
*Cause:    
*Action:

谢谢

Answer 1

intrument_mstr和component_txn表从未加入，这将为您提供Catersian加入。

select s.ST_SAMPLE_ID, s.st_cn_no as CNNumber,
s.st_smptyp as SampleType,
s.st_wasgrp as WasteCode,
s.st_wascod as WasteCategory,
s.st_received_dt as ReceivedDate,
s.st_wastyp_name as WasteType,
s.st_status as SampleStatus,
s.st_dispose_ind as DisposalStatus,
s.st_container as SampleContainer,
s.st_smppnt as SamplePoint,
s.st_nature as SampleNature,
c.scm_name as Color,
cm_client_name,
TC.CM_COMPO_NAME as "COMPONENT",
CM_SYMBOL as SYM,
CT_UNIT_Name as UOM,
CT_METHOD_NAME as "METHOD",
ct_det_status as "REP. LIMITS",
ct_ts_status as "TEST SPEC.",
o.ct_due_dt as "DUE DATE",
ct_result as "RESULT",
ct_rep as "REP",
ct_version as "VER"
from sample_txn s,
     sample_color_mstr c,
     client_mstr cm,
     component_txn o,
     codes_master cm,
     component_mstr tc,
     instrument_mstr i
where s.st_color=scm_auto_no (+)
 and st_client_id=cm_client_id 
 and st_year='13' 
 and s.st_lab_id='R'
 and to_char(s.st_received_dt, 'MON') = 'FEB'