oops... my goof... I read it too quickly...
ok... one more stupid question... can you not do an "insert into t1 (select
'a','b',min(f)-1 from t2)"?
- Greg
Greg Krasnow
HNC Software Inc.
Financial Solutions Group
Senior Software Engineer
Email: gak(at)hnc(dot)com
Direct Phone: 619.799.8341
Fax: 619.799.8036