Professional Web Applications Themes

Query.. How? - Microsoft SQL / MS SQL Server

Simple Question, i have 2 tables, Authors(Id,Author) and Books(Id,BookName,AuthorID), how can i do a query to return me all the authors that has no books published?? Thanks. Alex....

  1. #1

    Default Query.. How?

    Simple Question, i have 2 tables, Authors(Id,Author) and
    Books(Id,BookName,AuthorID), how can i do a query to return me all the
    authors that has no books published??

    Thanks.
    Alex.


    Ale Guest

  2. #2

    Default Re: Query.. How?

    Try:

    select
    a.*
    from
    Authors a
    where not exists
    (
    select
    *
    from
    Books b
    where
    b.AuthorID = a.Id
    )


    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Ale K." <com> wrote in message news:phx.gbl...
    Simple Question, i have 2 tables, Authors(Id,Author) and
    Books(Id,BookName,AuthorID), how can i do a query to return me all the
    authors that has no books published??

    Thanks.
    Alex.



    Tom Guest

  3. #3

    Default Re: Query.. How?

    Perfect, it Worked!!!

    Thanks.
    Alex.
    "Tom Moreau" <spam.me.cips.ca> wrote in message news:phx.gbl...
    Try:

    select
    a.*
    from
    Authors a
    where not exists
    (
    select
    *
    from
    Books b
    where
    b.AuthorID = a.Id
    )


    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Ale K." <com> wrote in message news:phx.gbl...
    Simple Question, i have 2 tables, Authors(Id,Author) and
    Books(Id,BookName,AuthorID), how can i do a query to return me all the
    authors that has no books published??

    Thanks.
    Alex.


    Ale Guest

Similar Threads

  1. Creating data query from mySQL stored query!?
    By johnegbert in forum Coldfusion Database Access
    Replies: 2
    Last Post: August 5th, 09:28 PM
  2. Query of Queries on query New type query
    By david_h in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 08:55 PM
  3. Replies: 1
    Last Post: July 2nd, 09:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139