That's rather vague.

Clay Shannon,
Dimension 4 Software
-----Original Message-----
From: Milan Babuskov [mailto:milanb@...]
Sent: Wednesday, February 09, 2005 10:56 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to popul8 many-to-many table with SQL


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




Yahoo! Groups Links