Question

sql命令未正确结束

SELECT T4.ID AS T4ID,
T5.PERIGEE_ANGLE AS T5PERIGEE_ANGLE,
T5.HNEAR_ANGLE AS T5HNEAR_ANGLE,
T5.DESCRIPTION AS T5DESCRIPTION,
V1.T1ID,
V1.T3SCENEID,
V1.T3PRODID,
V1.T3CAPTION,
V1.T3THUMBNAILS,
V1.T3STORAGE_STATUS,
V1.T3ARCHIVE_PACKAGE_ID,
V1.T3FTPTGZPATH,
V1.T3PRODORIEN,
V1.T3IMGPRODDATE,
V1.T3PROSTY,
V1.T3PROLEV,
V1.T3CORLEV,
V1.T3SRCDESC,
V1.T3INTLEAFMAT,
V1.T3BANDCNT,
V1.T3BANDS,
V1.T3STATEMENT,
V1.T3SUPPINFO,
V1.T3RADCALDATAV,
V1.T3CANCALINAV,
V1.T3COODSYSID,
V1.T3COODTYP,
V1.T3ELLID,
V1.T3PROJID,
V1.T3ZONENUM,
V1.T3DISTFORMAT,
V1.T3RESAMPTECH,
V1.T3DATAUPPERLEFTLAT,
V1.T3DATAUPPERLEFTLONG,
V1.T3DATAUPPERRIGHTLAT,
V1.T3DATAUPPERRIGHTLONG,
V1.T3DATALOWERLEFTLAT,
V1.T3DATALOWERLEFTLONG,
V1.T3DATALOWERRIGHTLAT,
V1.T3DATALOWERRIGHTLONG,
V1.T3PRODUCTUPPERLEFTLAT,
V1.T3PRODUCTUPPERLEFTLONG,
V1.T3PRODUCTUPPERRIGHTLAT,
V1.T3PRODUCTUPPERRIGHTLONG,
V1.T3PRODUCTLOWERLEFTLAT,
V1.T3PRODUCTLOWERLEFTLONG,
V1.T3PRODUCTLOWERRIGHTLAT,
V1.T3PRODUCTLOWERRIGHTLONG,
V1.T3ABSCALCOEF,
V1.T3GCP,
V1.T3PRODUCTTYPE,
V1.T3SCENECOUNT,
V1.T3SCENESHIFT,
V1.T3EPHEDATA,
V1.T3ATTIDATA,
V1.T3MARK,
V1.T3PRODUCTPATH,
V1.T3MARKS,
V1.T3MARKC,
V1.T3IMPORTDATABASETIME

FROM G10_SENSOR T4,
G10_SATELLITE T5,
G10_VIEW_08 V1
WHERE V1.T2.SENID = T4.ID
V1.T2.PLATID = T5.ID
T4.PLATID = T5.ID;
where之后说“sql命令未正确结束”，应该怎么改？是不是格式有误？本人边做边学，对sql还不太了解

Answer 1

WHERE V1.T2.SENID = T4.ID
V1.T2.PLATID = T5.ID
T4.PLATID = T5.ID;
这里有三个条件，这三个条件之间的关系没有写（AND，还是OR？)
例如，AND关系
WHERE V1.T2.SENID = T4.ID
AND V1.T2.PLATID = T5.ID
AND T4.PLATID = T5.ID;

Answer 2

where 之后,,,,每个条件前的 and 呢?

WHERE V1.T2.SENID = T4.ID
and V1.T2.PLATID = T5.ID
and T4.PLATID = T5.ID;

Answer 3

where 后面的条件没有and