Hi Neil, select login_id, ip_address from basic_table group by login_id,ip_address having count(login_id,ip_address)>1
this should work in case you want to see also the list of emails add: group_concat(email_address,',') as list_of_used_emails to the select fields. Claudio 2011/3/2 Tompkins Neil <neil.tompk...@googlemail.com> > Hi > > I've the following basic table > > login_id > email_address > ip_address > > 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 ? > > Thanks, > Neil > -- Claudio
