Professional Web Applications Themes

IN clause with 2 fields - Microsoft SQL / MS SQL Server

How to use IN clause in SQL Server 2000 envolving more than 1 field? For instance: select * from mytable1 where myfield1,myfield2 in (select myfield1,myfield2 from mytable2) I already tried "where <myfield1,myfield2> in", using "<" and ">", but it generated error. Thanks, Gustavo...

  1. #1

    Default IN clause with 2 fields

    How to use IN clause in SQL Server 2000 envolving more than 1 field?
    For instance:

    select *
    from mytable1
    where myfield1,myfield2 in
    (select myfield1,myfield2
    from mytable2)

    I already tried "where <myfield1,myfield2> in", using "<" and ">", but it
    generated error.

    Thanks,
    Gustavo


    Gustavo Pizzini Becker Guest

  2. #2

    Default Re: IN clause with 2 fields

    Use EXISTS instead. Or an inner join..

    .... where exists (select * from mytable2 where
    mytable1.myfield1 = mytable2.myfield1 and
    mytable1.myfield2 = mytable2.myfield2)

    or

    select t1.*
    from mytable1 t1 inner join mytable2 t2
    on t1.myfield1 = t2.myfield1 and
    on t1.myfield2 = t2.myfield2


    Gustavo Pizzini Becker wrote:
    > How to use IN clause in SQL Server 2000 envolving more than 1 field?
    > For instance:
    >
    > select *
    > from mytable1
    > where myfield1,myfield2 in
    > (select myfield1,myfield2
    > from mytable2)
    >
    > I already tried "where <myfield1,myfield2> in", using "<" and ">",
    > but it generated error.
    >
    > Thanks,
    > Gustavo

    Bob Barrows Guest

Similar Threads

  1. Using IN in a WHERE clause
    By drmaves in forum Coldfusion Database Access
    Replies: 15
    Last Post: September 5th, 05:05 PM
  2. CF MX 6 WHERE Clause
    By Jeremy5431 in forum Macromedia ColdFusion
    Replies: 13
    Last Post: May 2nd, 02:26 PM
  3. Replies: 0
    Last Post: November 21st, 04:58 PM
  4. #26351 [NEW]: Incorrect handling of Null Fields/Numerical Fields with '0'
    By jabberwocky at ibplanet dot com in forum PHP Development
    Replies: 0
    Last Post: November 21st, 04:47 PM
  5. update and having clause??
    By JT in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 2nd, 07:52 PM

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