counting two or more tables in one query

[advan]

Is there a way whereby I can use only 1 query to do count on 2 or more tables?

/* its not working */
"SELECT count(form.id) AS form_count, count(members.id) FROM forms, members";

Is just like getting a total count of 1 table and another total count of 2nd table. If its possible, I might want to calculate more table count in 1 query. If anyone have ideas?

[Jack_Slocum]

Yes you can do it. The syntax should be something like this:

select count(DISTINCT form.id) as form_count, count(DISTINCT members.id) as member_count from forms, members