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.
Bookmarks