I know how to do this in an insert, using (?,?,? etc) but how do i do this in a simple select using a reference link (lookup)?
the sql i have is:
Code: Select all
SELECT A.LOCA_ID
, B.IP_ID
, A.ADR_TYCD
, A.ADR_DES_1
, A.ADR_DES_2
, A.ADR_DES_3
, A.ADR_DES_4
, A.ADR_DES_5
, A.ADR_DES_6
, A.ADR_DES_7
, A.ADR_DES_8
, A.ADR_DES_9
, A.ADR_DES_10
, A.ADR_DES_1A
, A.ADR_DES_2A
, A.ADR_DES_3A
, A.ADR_DES_4A
, A.ADR_DES_5A
, A.ADR_DES_6A
, A.ADR_DES_7A
, A.ADR_DES_8A
, A.ADR_DES_9A
, A.ADR_DES_10
from #pUKDWSCHEMA#.ADR A, #pUKDWSCHEMA#.LOCA_RELN B
where A.LOCA_ID = B.LOCA_ID
and B.#pLkUp#=IPID
and B.IP_LOCA_RELN_TYCD in ( '1', '4')
order by B.IP_LOCA_RELN_TYCD ASC, B.REC_ACDT DESC
fetch first 1 rows only
;
Any ideas or suggestions?
Cheers