Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Red face Unanswered: NEED HELP (extract records)!!

    I have a 2 tables, one with good emails a another with bad emails, i need to have a table with good email, i need to extract bads !!!

    please need help ....

    thanx !!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: NEED HELP (extract records)!!

    Originally posted by superj
    I have a 2 tables, one with good emails a another with bad emails, i need to have a table with good email, i need to extract bads !!!

    please need help ....

    thanx !!
    According to what you explained you have what you need ... Unless you'd like to clarify ...

  3. #3
    Join Date
    Feb 2004
    Posts
    26

    Re: NEED HELP (extract records)!!

    Originally posted by M Owen
    According to what you explained you have what you need ... Unless you'd like to clarify ...
    I need a query to do that !!!

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    I don't understand ... You have a table for good emails and one for bad ... Where are all the emails at right now? Are they in either of those tables?

  5. #5
    Join Date
    Feb 2004
    Posts
    26
    Originally posted by M Owen
    I don't understand ... You have a table for good emails and one for bad ... Where are all the emails at right now? Are they in either of those tables?
    ok, I'm sorry my first table have email ( no good email ) and the other table have bad emails ... I need to extract the bad emails ...

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by superj
    ok, I'm sorry my first table have email ( no good email ) and the other table have bad emails ... I need to extract the bad emails ...
    Extract the emails to do what? Retrieve to put where? Doing a query is simple:

    SQLString="SELECT * FROM BadEMailTable;"

    What do you want to hold the result set?

  7. #7
    Join Date
    Feb 2004
    Posts
    26
    Originally posted by M Owen
    Extract the emails to do what? Retrieve to put where? Doing a query is simple:

    SQLString="SELECT * FROM BadEMailTable;"

    What do you want to hold the result set?
    This is my querry

    SELECT *
    From tableEmail , tableBadEmail
    where tableEmail.email <> tableBadEmail.email

    this querry dont work !!!

  8. #8
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by superj
    This is my querry

    SELECT *
    From tableEmail , tableBadEmail
    where tableEmail.email <> tableBadEmail.email

    this querry dont work !!!
    Well ... An unmatched query ... Try:

    SELECT *
    FROM tableEmail LEFT JOIN tableBadEmail ON tableEmail.email = tableBadEmail.email WHERE (( tableEmail.email) Is Null);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •