select *, sum_rows as ( select count(*) from table2; ) from table1;
-------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il --------------------------
Responses
Re: sub select at 2001-08-30 12:34:24 from Tod McQuillin