INET_NTOA Issues

[Luke Powel]

I am stumped, I cannot find any way to do this , but this is the closest i have came.

I need to select from two tables containing ip addresses, and i need to match them and put them into a new table. My problem is that one table has ip addresses as integers and the other as an actual IP.

If anyone could help me out that would be great.


select ipaddress from Ipcountershistory.Ipcountershistory i, registrations r where i.inet_ntoa(ipaddress) = r.ip;