try your query i become id 1,2,3 and that's not that i want. I want
only id 1,3
regards Micha
-Ursprüngliche Nachricht-
Von: Jonny Stendahl [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 22. Mai 2002 08:27
An: Spielberg Micha; [EMAIL PROTECTED]
Betreff: SV: Subselect or other way?
OK
It works fine
thank you
regards Micha
-Ursprungliche Nachricht-
Von: Sammy Lau [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 22. Mai 2002 09:17
An: Spielberg Micha
Cc: [EMAIL PROTECTED]; Jonny Stendahl
Betreff: Re: AW: Subselect or other way?
You've to do a self join to get
Hi,
i have a table like this:
Fields: id,nr
I want now a query like this:
SELECT id FROM Table WHERE nr=3D123 and (SELECT id FROM Table
WHERE nr=3D456).
Must i do this with a temp Table or ist there any other way to do this
with Joins?
I hope someone can help me..
regards Micha
-
Von: Jonny Stendahl [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 22. Mai 2002 07:53
An: Spielberg Micha; [EMAIL PROTECTED]
Betreff: SV: Subselect or other way?
This is a simple SELECT statement:
SELECT id
FROM Table
WHERE nr=3D123
AND id = 3D456
this gives you probably one record