select ta.a, count(tb.*) .... or count(tb.a) ..... from ta, tb where ta.a = tb.a
Barbara George Manager, Business Information Pick 'n Pay, Cape Town, South Africa
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2001 Indexes