I have two tables with warehouse information. the first tells me the code,
names and units of all the products I have (even if they are not in stock).
The second has movement information, from witch I need the batch number and
the quantity (with only the ones I have in stock).

I would like to merge them together getting a table with the Code; Name;
Unit; batch and quantity.

Thank you, for your help. Sorry about my English.