Hi,
I have two tables, nutritions and food_options.
nutritions has two fields, fooditem_id, taken and .
food_options has two fields, fooditem_id and taken.
fooditem_id in nutritions and food_options will point to id in
food_items table(third table).
I want to select all records from nutritions and food_options into a new
table, C with Fields fooditem_id and taken. This means I need to
combine the values of fooditem_id in nutritions and fooditem_id in
food_options into one field (fooditem_id), including the duplicates in
both tables.
EX:
nutritions
id fooditem_id taken
1 23 1
2 23 1
food_options
id fooditem_id taken
1 34 1
C
id fooditem_id taken
1 23 1
2 23 1
3 34 1
How can I do this?
thanks,
srinath