Hi I would like to know how to create a MySQL statement with Count(*) and natural join.

I have a table named iphead and another table named even. iphead has a number of IP addresses and I would like to count the total number using count(*). Next, the even table has the corresponding signatures which I would like to join to the counted IP addresses using even.sid=iphead.sid.

Can anyone help me?

Kindly post the tables structures also post the query that you are working on.

It will be something like (I'm assuming your table structure)

SELECT even.signature, COUNT(*) FROM even 
INNER JOIN even.sid=iphead.sid
GROUP BY even.sid