Clay Shannon wrote:

> --even if the above worked (which it doesn't because the select selects
> multiple records), I would have to manually enter the deptno each time. How
> can I populate the whole table with one SQL statement--is it possible? I'm
> sure it must be.

You can write a trigger to do it.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org