1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,276
    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