Professional Web Applications Themes

Full OUTER - MySQL

What's the syntax for a FULL OUTER JOIN in MySQL? TIA Paul...

Sponsored Links
  1. #1

    Default Full OUTER

    What's the syntax for a FULL OUTER JOIN in MySQL?

    TIA
    Paul


    Sponsored Links
    Paul Lautman Guest

  2. #2

    Default Re: Full OUTER

    Paul Lautman wrote:
    > What's the syntax for a FULL OUTER JOIN in MySQL?
    SELECT ...
    LEFT JOIN ...

    UNION

    SELECT ...
    RIGHT JOIN ...

    FULL OUTER JOIN is currently not supported, so you have to simulate it.

    Greetings
    Kai

    --
    This signature is left as an exercise for the reader.
    Kai Ruhnau Guest

Similar Threads

  1. OUTER JOIN
    By jorgepino in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: May 23rd, 12:59 PM
  2. FULL OUTER JOIN
    By beckydub in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 13th, 02:54 PM
  3. Apparently I don't understand full outer joins....
    By Ben in forum PostgreSQL / PGSQL
    Replies: 5
    Last Post: January 26th, 09:35 PM
  4. Outer Glow: Best way to achieve correct, fast, memory-saving Outer Glow
    By Oliver Bartosik in forum Adobe Illustrator Macintosh
    Replies: 0
    Last Post: March 2nd, 02:37 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