Dear All,

This is my problem:

1)I have a table with these fields (columns):
- id
- ideas_id
- boxes_id
- status

2)and another table with these fields (columns):
- id
- name
- description

the field "boxes_id" in the first table has the same meaning of the field "id" in the second box; but in the second table I have less values;

what I want to get is:
a new table with the same fields of table 1;
the condition that a row of table 1 has to verify to be part of the resultant table is: the value of "boxes_id" has to match any value of "id" in table 2; I don't want to specify a value of "id", I want to consider all the different "id" values in table 2 in the check condition.

I hope to have made me clear. I am not sure!

Thank you very much for the help!!
Mirco.