From: Tompkins Neil Date: March 2 2011 11:00am Subject: Query help List-Archive: http://lists.mysql.com/mysql/224548 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e64cbb30b7d880049d7dd074 --0016e64cbb30b7d880049d7dd074 Content-Type: text/plain; charset=ISO-8859-1 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 --0016e64cbb30b7d880049d7dd074--