>From: Tompkins Neil [mailto:neil.tompkins@stripped]
>Sent: Wednesday, March 02, 2011 6:00 AM
>Subject: Query help
>I've the following basic table
>I want to extract all records from this table in which a user has used the
>same IP address but different email address to login ?
[JS] I haven't looked at my code lately, but I'm pretty sure that
COUNT(*) > 1;
is what you want. You don't need to group on login_id. And, as Claudio said,
ip_address, GROUP_CONCAT(login_id, ', ') AS list_of_login_ids
will give you the IP addresses as well.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com