Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Unanswered: mysql join problem

    I have this query;

    SELECT table1.Title, table2.ID, table2.Val FROM table1 INNER JOIN table2 ON table1.No = table2.No WHERE table1.TitleLike '%keyword%' AND ( table2.ID = 50 OR table2.ID = 51 OR table2.ID = 52 OR table2.ID = 53 ) ORDER BY table1.Title;

    but now I get four rows of results, one for each table2.ID, I tried group BY table1.Titlebut then it only shows the first table2.ID and the rest isn't shown, how should i fix it, I want 1 row for every table1.Title

    Thank you
    Last edited by Xia; 12-22-03 at 05:47.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    please describe what you want to do with this query.

    If you need to list each related row from table2

    Or just a one row ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •