Professional Web Applications Themes

Select Left Join AND Right Join - Microsoft SQL / MS SQL Server

Use FULL OUTER JOIN -- David Portas ------------ Please reply only to the newsgroup -- "DIEGO BUENDIA" <ES> wrote in message news:google.com... ...

  1. #1

    Default Re: Select Left Join AND Right Join

    Use FULL OUTER JOIN

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "DIEGO BUENDIA" <ES> wrote in message
    news:google.com... 


    David Guest

  2. #2

    Default Re: Select Left Join AND Right Join

    Here's the FULL OUTER JOIN version:

    SELECT COALESCE(A.fld1,B.fld1) AS fld1,
    A.ColA AS A_Val,
    B.ColB AS B_Val
    FROM test1 AS A
    FULL JOIN test2 AS B
    ON A.fld1 = B.fld1

    (thanks for the sample data, Kannan)

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Guest

Similar Threads

  1. Is left-join faster then inner join?
    By howachen@gmail.com in forum MySQL
    Replies: 5
    Last Post: March 5th, 07:11 AM
  2. Left Outer Join
    By Jared in forum MySQL
    Replies: 0
    Last Post: May 3rd, 03:31 AM
  3. left join limit 1
    By in forum MySQL
    Replies: 7
    Last Post: March 27th, 04:38 AM
  4. Left join isn't joining
    By Bill in forum MySQL
    Replies: 7
    Last Post: December 23rd, 04:47 PM
  5. left join problem
    By AK in forum IBM DB2
    Replies: 8
    Last Post: August 8th, 12:16 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