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!