[SOLVED] Merging two tables in mysql query !

[coool]

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

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

$sql="SELECT $fields FROM $tables WHERE $conditions";
?>

 

error: Id is ambiguous !!   ???

[pikemsu28]

$query = "SELECT $fields FROM FruitsTable WHERE $conditions UNION SELECT $fields FROM VegetablesTable WHERE $conditions";

 

 

[coool]

 

This is great 

 

Thanks alot