Table A (primary table)

-------

icontainerid

iadditiveiid

Table B (lookup table)

-------

iid

cinformation

Both fields in "table a" relate to "table b" via the "iid" field in "table

b".

In an SQL statement, I want to gather "cinformation" from "table b" twice

per record; once for the "icontainerid" and once for the "iadditiveid".

How?

--Brad