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?