On Fri, 04 May 2001, Roger Karnouk wrote:
> Something like this should work:
> select ip, mac, count(mac)
> from ipmac
> group by ip,mac having count(mac) > 1
> hope this helps
Yes! Thanks Roger - this is just the thing.
group by ip, mac having count(mac) > 1
returns nothing, 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 again.
--
Best regards,
Tony Hunter
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
