On Sat, Nov 05, 2005 at 01:10:13PM -0500, Matthew Terenzio wrote: > > I want a query to return all the rows from one table along with a count > of rows in another table that reference each returned row from the > first table.
Quick and dirty, should give you the idea... select *, (select count(*) from table2 where fkey=pkey) from table1; Hope this helps, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpWB9mIW2Bu4.pgp
Description: PGP signature
