Merging two tables in mysql query !

Discussion in 'MySQL' started by coool, Jul 17, 2007.

  1. coool

    coool New Member

    Joined:
    Jul 12, 2007
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    0
    Hi :)

    let's say I have two database tables

    FruitsTable
    Id..........name..........color
    13..........a..................green
    25..........k..................yellow
    32..........o..................red

    VegetablesTable
    Id..........name..........color
    13..........d..................green
    25..........g..................white
    32...........l..................red

    now can I do that ?

    PHP:
    <?php

    $fields
    ="Id,name";
    $tables="FruitsTable,VegetablesTabes";
    $conditions="color in 'green,red'";

    $sql="SELECT $fields FROM $tables WHERE $conditions";
    ?>
    error: Id is ambiguous !! :eek:
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,335
    Likes Received:
    377
    Trophy Points:
    83
    No you cannot do that and you are surely to get that error. Can you tell me what does Id mean in your $fields variable. I mean for which table it refer to. I cannot get that and so should the database will not be. Make it explicit like "FruitsTable.Id" or "VegetablesTabes.Id";
     
  3. coool

    coool New Member

    Joined:
    Jul 12, 2007
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    0
    I've got the problem solved by using UNION :)

    Thanks
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice