新手问题:SELECT "SAMPLE".SAMPLE_NUMBER,result.test_number,result.result_number,result.order_number, "SAMPLE".SAMPLED_DATE, "SAMPLE".PRODUCT,
"SAMPLE".SAMPLING_POINT,sampling_point.reported_name as sampling_reported_name, "SAMPLE".SAMPLE_TYPE,
"SAMPLE".PRODUCT_NAME, "SAMPLE".SAMPLE_DETAILNAME,
RESULT.REPORTED_NAME, RESULT.FORMATTED_ENTRY, "SAMPLE".PROD_EQUIP,
LPROD_EQUIP.EQUIP_CODE, LPROD_EQUIP.DESCRIPTION, RESULT.UNITS,
UNITS.DISPLAY_STRING, "SAMPLE".RELEASED, RESULT.SEND_TO_WEB,
"SAMPLE".SAMPLE_LOCATION
FROM "SAMPLE" INNER JOIN
RESULT ON
"SAMPLE".SAMPLE_NUMBER = RESULT.SAMPLE_NUMBER INNER JOIN
LPROD_EQUIP ON
"SAMPLE".PROD_EQUIP = LPROD_EQUIP.EQUIP_NAME INNER JOIN
UNITS ON RESULT.UNITS = UNITS.UNIT_CODE INNER JOIN sampling_point on sample.sampling_point=sampling_point.name
WHERE ("SAMPLE".RELEASED = 'T') AND (RESULT.SEND_TO_WEB = 'T')
order by sample.sample_number,result.test_number,result.order_number1.经检查,数据库中并没有名称为SAMPLE、RESULT、LPROD_EQUIP的表和视图,那这三个是什么东东?
2.为什么SAMPLE要加双引号,而RESULT和LPROD_EQUIP不用?
"SAMPLE".SAMPLING_POINT,sampling_point.reported_name as sampling_reported_name, "SAMPLE".SAMPLE_TYPE,
"SAMPLE".PRODUCT_NAME, "SAMPLE".SAMPLE_DETAILNAME,
RESULT.REPORTED_NAME, RESULT.FORMATTED_ENTRY, "SAMPLE".PROD_EQUIP,
LPROD_EQUIP.EQUIP_CODE, LPROD_EQUIP.DESCRIPTION, RESULT.UNITS,
UNITS.DISPLAY_STRING, "SAMPLE".RELEASED, RESULT.SEND_TO_WEB,
"SAMPLE".SAMPLE_LOCATION
FROM "SAMPLE" INNER JOIN
RESULT ON
"SAMPLE".SAMPLE_NUMBER = RESULT.SAMPLE_NUMBER INNER JOIN
LPROD_EQUIP ON
"SAMPLE".PROD_EQUIP = LPROD_EQUIP.EQUIP_NAME INNER JOIN
UNITS ON RESULT.UNITS = UNITS.UNIT_CODE INNER JOIN sampling_point on sample.sampling_point=sampling_point.name
WHERE ("SAMPLE".RELEASED = 'T') AND (RESULT.SEND_TO_WEB = 'T')
order by sample.sample_number,result.test_number,result.order_number1.经检查,数据库中并没有名称为SAMPLE、RESULT、LPROD_EQUIP的表和视图,那这三个是什么东东?
2.为什么SAMPLE要加双引号,而RESULT和LPROD_EQUIP不用?
2.去掉双引号在这里不会出任何问题. 如果双引号中存在小写字母就不能去掉了.