please please help me

[Harriet Rickman]

select FROM, query 2 kontaktperson, adress, postnummer, ort
delete from query 2 if kontaktperson+adress+postnummer+ort+e-post
help me to make this a korekt SQL string

 

[CyberDwarf]

Harriet
Try this:-

Select kontaktperson, adress, postnummer, ort From dbo.[query 2]

Delete from dbo.[query 2] if kontaktperson+adress+postnummer+ort+[e-post]

Was willst du mit diesem DELETE query machen? Normalerweise benuetzt man
WHERE....

Steve

 

[Harriet Rickman]

Thanks dwarf, i hope this will funktion now, im making a work at school and
i couldnt make this i have been strugeling whith it for some days now
thanks
--
Harriet

Harriet
Try this:-

Select kontaktperson, adress, postnummer, ort From dbo.[query 2]

Delete from dbo.[query 2] if kontaktperson+adress+postnummer+ort+[e-post]

Was willst du mit diesem DELETE query machen? Normalerweise benuetzt man
WHERE....

Steve