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: [EMAIL PROTECTED] Direct Phone: 619.799.8341 Fax: 619.799.8036
- [GENERAL] Select MIN() & MAX() Krasnow, Greg
- Re: [GENERAL] Select MIN() & MAX() Dimitri
- Re: [GENERAL] Select MIN() & MAX() Bruce Momjian
- Re: [GENERAL] Select MIN() & MAX() Jeremiah Davis
- Re: [GENERAL] Select MIN() & MAX() Krasnow, Greg
- Re: [GENERAL] Select MIN() & MAX() Dimitri
- Re: [GENERAL] Select MIN() & MAX() Bruce Momjian