Possible to join in a count(*)

2004-04-22 Thread Victor SpÄng Arthursson
Hi! Using mysql version 4.0.x, and would like to know if it is possible to join in a count(*) from a related table which count the number of corresponding posts in this per post in the first table? A little like: table1: +-+--+ | id | name

Re: Possible to join in a count(*)

2004-04-22 Thread Victoria Reznichenko
Victor Sp?ng Arthursson [EMAIL PROTECTED] wrote: Using mysql version 4.0.x, and would like to know if it is possible to join in a count(*) from a related table which count the number of corresponding posts in this per post in the first table? A little like: table1