Professional Web Applications Themes

select on two fields referencing one table - MySQL

I am using MySQL 5 and have two tables users with fields id, name messages with fields from_id, to_id from_id and to_id references id in users what I need is to get the name in users table for both from_id and to_id in one SQL statement. how can this be done? Thanks...

  1. #1

    Default select on two fields referencing one table

    I am using MySQL 5 and have two tables

    users
    with fields
    id, name

    messages
    with fields
    from_id, to_id

    from_id and to_id references id in users

    what I need is to get the name in users table for both from_id and
    to_id in one SQL statement.
    how can this be done?

    Thanks

    jmark@fastermail.com Guest

  2. #2

    Default Re: select on two fields referencing one table

    com wrote: 

    SELECT
    `u1`.`name` `from_name`,
    `u2`.`name` `to_name`
    FROM `messages` `m`
    JOIN `users` `u1` ON `m`.`from_id` = `u1`.`id`
    JOIN `users` `u2` ON `m`.`to_id` = `u2`.`id`


    Paul Guest

Similar Threads

  1. dynamically referencing form fields
    By jrichardson12 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: March 9th, 04:21 PM
  2. Referencing the Table Name
    By Dan J. in forum MySQL
    Replies: 1
    Last Post: March 4th, 09:00 AM
  3. Replies: 9
    Last Post: June 28th, 06:04 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