Update med tilføjelse af = med egen tabel

Vil du sætte address1 = T2.address2 ud fra din SELECT command?

Nop jeg vil tilføje address1 = T2.address2 på min sidste WHERE command men den genkender ikke T2, og når jeg sætter en ny SELECT command efter sidste WHERE brokker den sig :-(

Nu har jeg prøvet disse her men ligevidt hjælper det.... :-( HJÆLPPPPPPP

UPDATE    crm5.address
SET              address1 =
                          (SELECT    T2.address2
                            FROM          crm5.address T2
                            WHERE      T2.atype_idx = 2 AND address2 LIKE 'postboks%')
FROM        (SELECT    *
                      FROM          crm5.address) AS T2
WHERE    (crm5.address.atype_idx = 1) AND (crm5.address.owner_id = T2.owner_id) AND (T2.address2 LIKE 'postboks%')

UPDATE    crm5.address
SET              address1 =
                          (SELECT    T2.address2
                            FROM          crm5.address T2
                            WHERE      T2.atype_idx = 2 AND address2 LIKE 'postboks%')
FROM      crm5.address, crm5.address T2 
WHERE    (crm5.address.atype_idx = 1) AND (crm5.address.owner_id = T2.owner_id) AND (T2.address2 LIKE 'postboks%')

zeus999>The variable needs to be converted to a value. When you write

.... AND (T2.address2 LIKE 'postboks%')

it thinks that the value you are looking for is = 'postboks%'

So you need to use something like

"SELECT ......... AND (T2.address2 LIKE '" & postboks & "%')"

If the varíable is a number then you do not use ''

svar