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

    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

    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

    I've got the problem solved by using UNION :)

    Thanks
     

Share This Page