|
SELECT & MYSQL
|
|||
---|---|---|---|
#18+
Пытаюсь выполнить выборку: SELECT DP_Measurements.*, DP_Stations.Station_Name FROM DP_Measurements, DP_Stations WHERE DP_Measurements.Measurement_Station=DP_Stations.Station_ID AND DP_Measurements.Measurement_Station IN(fgh,uyty,df34,gfer,ASDF,swew,rtyj,-1) AND DP_Measurements.Measurements_Tour IN(6,-1) AND DP_Measurements.Measurement_Antenna IN(TRBROG,ATDM1C,TRMSST,TRMICG,-1) AND DP_Measurements.Measurement_Receiver IN(AO800A,ROG__8,ROGSNR,TR8000,TRMSSE,TRMSSI,TRMSST,TR4700,TR5700,-1) AND DP_Measurements.Measurement_Condition IN(2,1,-1) AND DP_Measurements.Measurement_Operator IN(ahae,sman,bakb,bogm,bond,bord,borb,cher,tsyb,erem,filv,ghos,goli,guli,guse,hagb,hamb,ilts,jall,kuzi,kyrg,maks,mand,mark,mihs,moln,novi,novo,nujn,neil,oper,osdn,pere,plat,reil,sabi,salo,savc,sham,shar,schi,sles,sliv,smir,song,sout,sult,susl,sych,tara,tiep,tshb,zayc,lgot,-1) AND DP_Measurements.Measurement_Organization IN(2,-1) AND DP_Measurements.Measurement_Translation IN(0,1,-1) ORDER BY DP_Measurements.Measurement_Time, DP_Stations.Station_Name ASC Получаю ошибку: ERROR 1054: Unknown column 'fgh' in 'where clause' Что не правильно? Хотя запрос: SELECT * FROM DP_Stations WHERE Station_Category IN(3,1,2,-1) and Station_Position IN(3,1,-1) ORDER BY Station_Name ASC - работает нормально MySQL 3.23.54 RedHat таблицы InnoDB ... |
|||
:
Нравится:
Не нравится:
|
|||
08.04.2004, 11:23 |
|
SELECT & MYSQL
|
|||
---|---|---|---|
#18+
Код: plaintext
Код: plaintext
... |
|||
:
Нравится:
Не нравится:
|
|||
08.04.2004, 11:41 |
|
|
start [/forum/topic.php?fid=47&fpage=688&tid=1855268]: |
0ms |
get settings: |
8ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
30ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
44ms |
get tp. blocked users: |
2ms |
others: | 351ms |
total: | 472ms |
0 / 0 |