AW: Subselect or other way?

Till: [EMAIL PROTECTED]; Jonny Stendahl Ämne: AW: Subselect or other way? I think my english ist too bad My table looks like this id nr --- 1 123 1 456 1 678 2 457 2 897 2 123 I want to select in a query only these id that have nr=123

Re: AW: Subselect or other way?

uniqe id's with nr = 123 OR nr = 456 and that is id = 1. // Jonny -Ursprungligt meddelande- Från: Spielberg Micha [SMTP:[EMAIL PROTECTED]] Skickat: den 22 maj 2002 08:13 Till: [EMAIL PROTECTED]; Jonny Stendahl Ämne: AW: Subselect or other way? I think my english ist

AW: AW: Subselect or other way?

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

AW: Subselect or other way?

I think my english ist too bad My table looks like this id nr --- 1 123 1 456 1 678 2 457 2 897 2 123 I want to select in a query only these id that have nr=123 and nr=456. In the example its only id 1. regards Micha -Ursprüngliche