SQL Query issue

Discussion in 'Programming' started by Notting, Oct 19, 2007.

0
  1. #1
    Query:


    SELECT members.mem_ID,
    CONCAT(members.firstname, ' ', UPPER(members.familyname) AS name
    FROM members
    WHERE members.active = 'Y'
    ORDER BY members.familyname

    returns error message:

    [​IMG]

    Can anyone work out what the problem here is?

    Thanks
    Notting
     
    Notting, Oct 19, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    Try this.
    
SELECT members.mem_ID,
CONCAT(members.firstname, ' ', UPPER(members.familyname)) AS name
FROM members
WHERE members.active = 'Y'
ORDER BY members.familyname
    Code (sql):
     
    nico_swd, Oct 19, 2007 IP
  3. Forrest

    Forrest Peon

    Messages:
    500
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    0
    #3
    My guess is you can't use "name" as an alias; it's probably reserved. Although the evil monkey is right, you're missing a closing parenthesis.
     
    Forrest, Oct 20, 2007 IP
  4. mhaye_01

    mhaye_01 Banned

    Messages:
    395
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #4
    what;s the use of using "members.mem_id and other if you are just calling from one table..
    your are joining two fieldnames but from same table right?
     
    mhaye_01, Oct 20, 2007 IP
  5. mhaye_01

    mhaye_01 Banned

    Messages:
    395
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #5
    SELECT mem_ID,
    CONCAT(firstname, ' ', UPPER(familyname)) AS name
    FROM members
    WHERE active = 'Y'
    ORDER BY familyname

    i think this will run t0o
     
    mhaye_01, Oct 20, 2007 IP
    Alexander the Great likes this.