Member Avatar for Pprog

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?

  • 3 Contributors
  • 2 Replies
  • 134 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for debasisdas

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

Member Avatar for mwasif

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.