$sql_find = "select distinct entries.router,INET_NTOA(entries.route),entries.mask,entries.route_type,INET_NTOA(entries.dstip),entries.metric,names.name,names.netid,entries.time from entries INNER JOIN names ON names.dstip = entries.dstip where entries.route <= INET_ATON('$rt') and entries.route_end >= INET_ATON('$rt') and route_type like '%ospf%'"; mysql> desc entries; +------------+-------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------------+------+-----+---------+-------+ | router | varchar(100) | YES | | NULL | | | route_type | varchar(10) | YES | | NULL | | | route | int(100) unsigned | YES | | NULL | | | route_end | int(100) unsigned | YES | | NULL | | | mask | int(11) | YES | | NULL | | | ad | int(11) | YES | | NULL | | | metric | int(11) | YES | | NULL | | | dstip | int(100) unsigned | YES | | NULL | | | time | varchar(50) | YES | | NULL | | | interface | varchar(75) | YES | | NULL | | +------------+-------------------+------+-----+---------+-------+ 10 rows in set (0.00 sec) mysql> desc names; +-------+-------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------------+------+-----+---------+-------+ | name | varchar(75) | YES | | NULL | | | dstip | int(100) unsigned | YES | | NULL | | | netid | int(100) unsigned | YES | | NULL | | +-------+-------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)