RE: select query?

othing, but if we use group by mac having count(mac) > 1 Then we get the number of different mac's using an ip. Can then query the mac for different IP's used. It would be nice to roll it all into one query and I'll work on that. Thanks

select query?

ype char(3) not null, flags char(3) not null, mac varchar(20) not null, mask char(1) not null, device varchar(8) not null, updated datetime not null, key (id), key (ip), primary key (ip); unique index id_idx (id) ); -- Best regards, T