Professional Web Applications Themes

SQL syntax problem - MySQL

Hello! I've got a little problem with mySQL syntax. I have two tables : candidate and CV_items. Cardinality is : for 1 candidate you can have multiple CV_items I'd like to Select in ONE SINGLE ROW the id of the candidate (id_candidate) and ALL the CV_items associated. so far I used : "SELECT * FROM candidate c RIGHT JOIN cv_items ON c.ID_CANDIDATE=cv.ID_CANDIDATE" , it gives me the infos I need BUT on separated rows ....

  1. #1

    Default SQL syntax problem

    Hello!

    I've got a little problem with mySQL syntax.

    I have two tables : candidate and CV_items. Cardinality is : for 1
    candidate you can have multiple CV_items

    I'd like to Select in ONE SINGLE ROW the id of the candidate
    (id_candidate) and ALL the CV_items associated.
    so far I used : "SELECT * FROM candidate c RIGHT JOIN cv_items
    ON c.ID_CANDIDATE=cv.ID_CANDIDATE" , it gives me the infos I need BUT
    on separated rows .

    reversed.K@gmail.com Guest

  2. #2

    Default Re: SQL syntax problem

    On 15 Nov 2006 10:18:56 -0800, com wrote: 

    The key word you're looking for is "pivot". I'll skip the rest of the
    answer as I've never done them under MySQL.

    --
    Life does not cease to be funny when people die any more than it ceases
    to be serious when people laugh.
    -- George Bernard Shaw
    Peter Guest

  3. #3

    Default Re: SQL syntax problem

    com wrote: 

    I'll offer you a better key word :-)

    Take a look at the GROUP_CONCAT function.


    Paul Guest

Similar Threads

  1. syntax problem
    By Mikael Hellström in forum ASP Database
    Replies: 12
    Last Post: April 7th, 09:40 PM
  2. <cfquery> syntax problem
    By samb1 in forum Macromedia ColdFusion
    Replies: 1
    Last Post: April 7th, 08:33 PM
  3. INSERT MAX(ID) Syntax problem
    By Targa in forum ASP Database
    Replies: 2
    Last Post: May 1st, 08:01 PM
  4. IE problem with -> syntax
    By Patrick in forum PHP Development
    Replies: 1
    Last Post: July 31st, 03:55 PM
  5. Syntax error problem
    By Stephany Young in forum Informix
    Replies: 1
    Last Post: July 17th, 04:47 AM

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