Select in DataAdapter dosen't work
Posted: Tue 19 Feb 2008 11:06
Hey
I try to use the following code in a DataAdapter:
But I always get the error, that the table offAuftrag dosen't exist.
Can you please help me
I try to use the following code in a DataAdapter:
Code: Select all
Create Temporary Table if not exists offAuftrag (KundenID BigInt);
Insert Into offAuftrag(Select KundenID from auftragbrille where Bewegung=0);
Insert Into offAuftrag(Select KundenID from auftraghandelsware where Bewegung=0);
SELECT distinct
kundenstamm.NName,
kundenstamm.VName,
kundenstamm.Titel,
kundenstamm.Anrede
FROM
kundenstamm where kundenstamm.KundenID=offAuftrag.KundenID
Can you please help me