XQuery equivalent to NOT IN (subquery)

[thecolour]

Hello all

I am looking for the XQuery exquivalent to something like

select field from table1 where field not in (select field from table2)

I have been trying the != operator but it's not what I'm looking for.

Many thanks
Tom

 

[Martin Honnen]

I am looking for the XQuery exquivalent to something like

select field from table1 where field not in (select field from table2)

/table1/field[not(. = /table2/field)]

 

[thecolour]

I am looking for the XQuery exquivalent to something like

select field from table1 where field not in (select field from table2)

/table1/field[not(. = /table2/field)]

Thanks very much Martin - that worked a treat!