SV: Subselect or other way?

2002 08:13 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

AW: Subselect or other way?

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

Re: AW: Subselect or other way?

- 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! You can use SELECT DISTINCT: SELECT DISTINCT id FROM Table WHERE nr=123 OR nr=456 this gives you all

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

Re: Subselect or other way?

: Wednesday, May 22, 2002 1:45 AM Subject: Subselect or other way? 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

Subselect or other way?

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

SV: Subselect or other way?

-Ursprungligt meddelande- Från: Spielberg Micha [SMTP:[EMAIL PROTECTED]] Skickat: den 22 maj 2002 07:46 Till: [EMAIL PROTECTED] Ämne: Subselect or other way? 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

AW: Subselect or other way?

- 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