mysql ?

• jpea

  how can I do a SELECT that will compare two values of an entry in a row with two other entries?

  so far i have
  SELECT DISTINCT firstName, emailAddress FROM ...

  this returns entries where either the firstName or emailAddress is the same. i have entries where the email address might be the same, but the first name isn't and i need to be able to retrieve those (it filters them out as duplicates right now).

  ideas?

  jpea

  Flag

• mxhxr100

  use a temp table. populate it with whatever your first query spits out, and then compare from there, joining to the temp table on the primary key.

  i work w/ MS SQL Server so I can't give you the exact mySQL syntax.

  If you want, give me more info and I'll take a crack @ it.

  mxhxr10 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel