Professional Web Applications Themes

New to Joines - Inner Join on 4 Tables - Coldfusion - Getting Started

I have four tables that I'm querying, I'm selecting all fields with the exception of the key_ID which is the field I'm joining on. Because I have so many tables I'm not sure what this is supposed to look like, should it be: SELECT table1.field, table2.field, table3.field, table4.field FROM table1 INNER JOIN table2 INNER JOIN table3 INNER JOIN table4 ON table1.field = table2.field = table3.field = table4.field WHERE table1.field=#URL.id# I ask because I've been playing with the code for a while and haven't been able to either research the solution or stumble on it. Red:-)...

  1. #1

    Default New to Joines - Inner Join on 4 Tables

    I have four tables that I'm querying, I'm selecting all fields with the
    exception of the key_ID which is the field I'm joining on. Because I have so
    many tables I'm not sure what this is supposed to look like, should it be:

    SELECT table1.field, table2.field, table3.field, table4.field
    FROM table1 INNER JOIN table2 INNER JOIN table3 INNER JOIN table4
    ON table1.field = table2.field = table3.field = table4.field
    WHERE table1.field=#URL.id#

    I ask because I've been playing with the code for a while and haven't been
    able to either research the solution or stumble on it.

    Red:-)

    FusionRed Guest

  2. #2

    Default Re: New to Joines - Inner Join on 4 Tables

    Actually, it would be:

    SELECT table1.field, table2.field, table3.field, table4.field
    FROM table1 INNER JOIN table2
    ON table1.field = table2.field
    INNER JOIN table3
    ON table1.field = table3.field
    INNER JOIN table4
    ON table1.field = table4.field
    WHERE table1.field=#URL.id#

    Kronin555 Guest

  3. #3

    Default Re: New to Joines - Inner Join on 4 Tables

    Many thanks for your help, once again.

    Red;->
    FusionRed Guest

Similar Threads

  1. Replies: 5
    Last Post: June 27th, 06:35 AM
  2. Listing join from tables...
    By createmedia in forum Coldfusion Database Access
    Replies: 5
    Last Post: June 5th, 09:02 PM
  3. Select, Join & field values - 2 tables
    By Justin Koivisto in forum MySQL
    Replies: 3
    Last Post: February 13th, 08:06 PM
  4. HELP.. Recordset JOIN tables
    By Addy_31 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 4th, 01:51 AM
  5. SELECT from multiple tables (not join though)
    By Madison Kelly in forum PostgreSQL / PGSQL
    Replies: 15
    Last Post: January 10th, 07:43 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