SQL statement

Article View: bit.databases.mssql-l

Article #80

Back to bit.databases.mssql-l Previous Next

#80

From: Geovanny Navarro-Bustos
Date: Sat, 22 Apr 2000 00:00

19 lines
1178 bytes

Hi everyone

I need to know what the following SQL statement is doing:

Select name, nationality
From authoer
Where name is in
          (Select name
           From publication
           Where isbn is in
                    (Select isbn
                    From book
                    Where isbn <>9444
                    And year is in
                                    (Select year
                                        From book
                                        Where isbn = 9444)))

your help is appreciated....

Technical Details

Message-ID: <5vVL4.9750$5D.21437@ozemail.com.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,410ac398cf9e3c98,start
X-Google-Attributes: gidf6611,public
From: "Geovanny Navarro-Bustos" <geovanny@ozemail.com.au>
Subject: SQL statement
Date: 2000/04/22
Message-ID: <5vVL4.9750$5D.21437@ozemail.com.au>
X-Deja-AN: 613900279
Distribution: world
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Trace: ozemail.com.au 956310593 210.84.37.93 (Fri, 21 Apr 2000 19:49:53 EST)
Organization: OzEmail Pty Ltd, Australia
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 21 Apr 2000 19:49:53 EST
Newsgroups: bit.databases.mssql-l