1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,283
    Likes Received:
    364
    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