Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!c16g2000yqd.googlegroups.com!not-for-mail From: Pedro Newsgroups: comp.databases.oracle.server Subject: SELECT in problem Date: Wed, 3 Mar 2010 05:45:24 -0800 (PST) Organization: http://groups.google.com Lines: 17 Message-ID: <45bf6476-f852-4ed0-bc97-4081c1622f13@c16g2000yqd.googlegroups.com> NNTP-Posting-Host: 201.77.115.224 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1267623924 30922 127.0.0.1 (3 Mar 2010 13:45:24 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 3 Mar 2010 13:45:24 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: c16g2000yqd.googlegroups.com; posting-host=201.77.115.224; posting-account=H78FYAoAAADYCg95Jz8K_UUiEmEUhO2r User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.8) Gecko/20100202 Firefox/3.5.8,gzip(gfe),gzip(gfe) Xref: news.cambrium.nl Good morning people. I need quiet an odd help in here. Let me see if I can explain it. I have an SELECT WHERE IN (). Let us say that I sent the following list of ids: 1, 2 and 3. There is only resulting records for the ID = 3, but I'd like to see all the ids, even if they don't have records... I expect the following result for instance: ID DESC 1 2 3 Test Any suggestion on how to do this? I have here the complete statement, but I don't think it would help for now...