Notes/Domino 4 and 5 Forum

Hi

I have a SQL newbie question.

I have this query:

Key = "''"
wQueryString = "SELECT DATO,CPRNR,MEDARBEJDERID FROM DFac_SalgKunde WHERE CPRNR != " & Key

In another query I want to retrieve MEDARBEJDER which is based on MEDARBEJDERID in the first query. MEDARBEJDER is found in another table.

Do I need to save the document first in order to take MEDARBEJDERID with me and use it in a new query?

Thanks in advance!