Есть две таблицы tpam_09, и tpam_09.remark, мне нужно вывести поля 2 раза, но первый раз заджойнить на одно значение, а второй на другое? как это можно сделать?


Select
tpam.tpam_09_remark.data_n1,tpam.tpam_09_remark.data_n1, tpam.tpam_09.pipe_n, tpam.tpam_09_remark.remark,
tpam.tpam_09_remark.data_n1, tpam.tpam_09_remark.data_n1, tpam.tpam_09.pipe_n, tpam.tpam_09_remark.remark
from tpam.tpam_09
LEFT JOIN tpam.tpam_09_remark
ON (tpam.tpam_09.pipe_n = tpam.tpam_09_remark.pipe_n) AND (tpam.tpam_09_remark.wp = 03)
LEFT JOIN tpam.tpam_09_remark
ON (tpam.tpam_09.pipe_n = tpam.tpam_09_remark.pipe_n) AND (tpam.tpam_09_remark.wp = 09)

вот так писал, но выдает только = 03, можно законтрить?

Dshedoo,

через select, я же код кидал?

Dshedoo,

в этом и вопрос, я не могу понять как правильно написать, пробовал через as, но он ошибку выдает

londinium,

Большое спасибо, а его получится вставить в этот запрос?
Select tpam.tpam_09.manufacture, tpam.tpam_09.standart, tpam.tpam_09.pipe_od, tpam.tpam_09.pipe_wall, tpam.tpam_09.grade, tpam.tpam_09.heat_n, tpam.tpam_09.pipe_tenar, tpam.tpam_09.mill_ord, tpam.tpam_09.LENGTH, tpam.tpam_09.po_n, TPAM.TPAM_09.ITEM_CODE, tpam.tpam_09.COATERS, tpam.tpam_09.pipe_n as pipe_n1, tpam.tpam_09.type, tpam.tpam_09.od, tpam.tpam_09.date1, tpam.tpam_09.mpa, tpam.tpam_09.user1, tpam.tpam_09.pr1, tpam.tpam_09.pr2, tpam.tpam_09.CRN, tpam.tpam_09.DD, tpam.tpam_09.tenaris, tpam.tpam_09.STATUS_FLAG,
tpam.TPam_09_Remark.data_n1, tpam.TPam_09_Remark.Data_n1, tpam.tpam_09.pipe_n as pipe_n2, tpam.TPam_09_Remark.Remark,
tpam.tpam_09_wp05.data_n1, tpam.tpam_09_wp05.data_n1, tpam.tpam_09_wp05.shift, tpam.tpam_09_wp05.sec, tpam.tpam_09.pipe_n, tpam.tpam_09_wp05.pipe_size, tpam.tpam_09_wp05.batch_red, tpam.tpam_09_wp05.batch_gold, tpam.tpam_09_wp05.inspekt, tpam.tpam_09_wp05.tracking, tpam.tpam_09_wp05.lot, tpam.tpam_09_wp05.remark1,
tpam.tpam_09_wp06.data_n1 as data_n1wp6, tpam.tpam_09_wp06.data_n1 as data_n1wp6, tpam.tpam_09_wp06.shift1, tpam.tpam_09_wp06.sec2, tpam.tpam_09.pipe_n, tpam.tpam_09_wp06.result, tpam.tpam_09_wp06.Q_ty ,
tpam.tpam_09_remark.data_n1 as data_n1Remark, tpam.tpam_09_remark.data_n1 as data_n1Remark, tpam.tpam_09.pipe_n, tpam.tpam_09_remark.remark,
tpam.tpam_09_wp10.data_n5,tpam.tpam_09_wp10.data_n5,tpam.tpam_09_wp10.shift5,tpam.tpam_09.pipe_n,tpam.tpam_09_wp10.LENGTH51,tpam.tpam_09_wp10.status51,tpam.tpam_09_wp10.remark51,tpam.tpam_09_wp10.status51,tpam.tpam_09_wp10.remark51,tpam.tpam_09_wp10.STRIP5,tpam.tpam_09_wp10.LENGTH52,tpam.tpam_09_wp10.test5,tpam.tpam_09.mtc,tpam.tpam_09.remark5,
tpam.tpam_09_wp12.data6, tpam.tpam_09.Pipe_n,tpam.tpam_status.description, tpam.tpam_09_wp12.bt, tpam.tpam_09_wp12.st6,
tpam.tpam_09.DATE7, tpam.tpam_09.pipe_n as pipe_n6, tpam.tpam_09.DJW, tpam.tpam_09.DATE8, tpam.tpam_09.WEEK, tpam.tpam_09.pipe_n as pipe_n7, tpam.tpam_09.WELD, tpam.tpam_09.LENGTH8, tpam.tpam_09.DATE11, tpam.tpam_09.STATUS2,
tpam.tpam_09.RET_DATE, tpam.tpam_09.pipe_n as pipe_n8, tpam.tpam_09.RET_INSPST, tpam.tpam_09.RET_RRDATE, tpam.tpam_09.RET_FIND, tpam.tpam_09.RET_CRN, tpam.tpam_09.RET_SRN, tpam.tpam_09.RET_DD,
tpam.tpam_09.DATE10, tpam.tpam_09.pipe_n as pipe_n9, tpam.tpam_09.Weld, tpam.tpam_09.Length8, tpam.tpam_09.NOM
from tpam.tpam_09

left JOIN tpam.tpam_09_remark
ON tpam.tpam_09.pipe_n = tpam.tpam_09_remark.pipe_n and tpam.tpam_09_remark.wp = 03

left JOIN tpam.tpam_09_wp05
ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp05.pipe_n

left JOIN tpam.tpam_09_wp06
ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp06.pipe_n

left JOIN tpam.tpam_09_remark
ON tpam.tpam_09.pipe_n = tpam.tpam_09_remark.pipe_n and tpam.tpam_09_remark.wp = 09

left JOIN tpam.tpam_09_wp10
ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp10.pipe_n

left JOIN tpam.tpam_09_wp12
ON tpam.tpam_09.pipe_n = tpam.tpam_09_wp12.pipe_n
left join tpam.TPAM_STATUS
On tpam_09.status = tpam.tpam_status.kod

50Smradosti,

Сам додумался, спасибо всем