SELECT g.G6_DETECTION_ID G6_DETECTION_ID, t.veh_clzzqymc sccmc, t.veh_clxh vehicle_model, g.VIN VIN, t.VIN TVIN, tt.VIN TTVIN, tt.CAR_TYPE CARTYPE, tt.XXGKBH XXGKBH, t.VEH_CLPP SB, t.VEH_CPSCDZ SCCDZ, to_char( t.VEH_CLSCRQ, 'yyyy"年"mm"月"dd"日"' ) SCDATE, t.VEH_FDJH FDJH, g.FDJSB FDJSB, g.FDJSCCDZ FDJSCCDZ, g.RH RH, g.ET ET, g.AP AP, g.TESTTYPE TEST_TYPE, g.TESTNO TESTNO, g.TESTDATE TEST_DATE, g.APASS APASS, g.OPASS OPASS, g.OTESTDATE OTESTDATE, g.EPASS EPASS, g.RESULT RESULT, g.YR YR, g.ANALYMANUF ANALYMANUF, g.ANALYNAME ANALYNAME, g.ANALYMODEL ANALYMODEL, g.ANALYDATE ANALYDATE, g.DYNOMODEL DYNOMODEL, g.DYNOMANUF DYNOMANUF, g.ISUPLOAD ISUPLOAD, g.UPLOADDATE UPLOADDATE, g.ISUPLOADSECCESS ISUPLOADSECCESS, g.UPLOADUSER UPLOADUSER, g.UPLOADPERSON UPLOADPERSON, g.UPLOADMES UPLOADMES, g.ISAUTOUPLOAD, t.is_sample ISSAMPLE, t.FRIST_PRINT_DATE BANCI, g.OBDINSPECTOR, SUBSTR( g.VIN, 8, 1 ) AS DLLX, T_DLLX.NAME AS DLLXNAME FROM G6_DETECTION_RESULT g LEFT JOIN T_VEHCERT_PRINT t ON g.VIN = t.VIN LEFT JOIN T_HBBQ_PRINT tt ON g.VIN = tt.VIN LEFT JOIN T_DLLX ON SUBSTR( g.VIN, 8, 1 ) = T_DLLX.CODE WHERE tt.car_type!='E' 通过car_type查询出来的数据应该有五条,但是自动去除car_type为空的四条数据,怎么做可以不去掉这四条数据
时间: 2024-02-21 09:00:40 浏览: 177
你可以使用以下 SQL 语句来查询出所有的数据,包括 car_type 为空的数据:
```
SELECT
g.G6_DETECTION_ID G6_DETECTION_ID,
t.veh_clzzqymc sccmc,
t.veh_clxh vehicle_model,
g.VIN VIN,
t.VIN TVIN,
tt.VIN TTVIN,
tt.CAR_TYPE CARTYPE,
tt.XXGKBH XXGKBH,
t.VEH_CLPP SB,
t.VEH_CPSCDZ SCCDZ,
to_char(t.VEH_CLSCRQ, 'yyyy"年"mm"月"dd"日"') SCDATE,
t.VEH_FDJH FDJH,
g.FDJSB FDJSB,
g.FDJSCCDZ FDJSCCDZ,
g.RH RH,
g.ET ET,
g.AP AP,
g.TESTTYPE TEST_TYPE,
g.TESTNO TESTNO,
g.TESTDATE TEST_DATE,
g.APASS APASS,
g.OPASS OPASS,
g.OTESTDATE OTESTDATE,
g.EPASS EPASS,
g.RESULT RESULT,
g.YR YR,
g.ANALYMANUF ANALYMANUF,
g.ANALYNAME ANALYNAME,
g.ANALYMODEL ANALYMODEL,
g.ANALYDATE ANALYDATE,
g.DYNOMODEL DYNOMODEL,
g.DYNOMANUF DYNOMANUF,
g.ISUPLOAD ISUPLOAD,
g.UPLOADDATE UPLOADDATE,
g.ISUPLOADSECCESS ISUPLOADSECCESS,
g.UPLOADUSER UPLOADUSER,
g.UPLOADPERSON UPLOADPERSON,
g.UPLOADMES UPLOADMES,
g.ISAUTOUPLOAD,
t.is_sample ISSAMPLE,
t.FRIST_PRINT_DATE BANCI,
g.OBDINSPECTOR,
SUBSTR(g.VIN, 8, 1) AS DLLX,
T_DLLX.NAME AS DLLXNAME
FROM
G6_DETECTION_RESULT g
LEFT JOIN T_VEHCERT_PRINT t ON g.VIN = t.VIN
LEFT JOIN T_HBBQ_PRINT tt ON g.VIN = tt.VIN
LEFT JOIN T_DLLX ON SUBSTR(g.VIN, 8, 1) = T_DLLX.CODE
WHERE
tt.car_type != 'E' OR tt.car_type IS NULL
```
这样就可以保留 car_type 为空的数据了。
阅读全文
相关推荐


















