Announcement

Collapse
No announcement yet.

Very basic Access query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Very basic Access query

    Very basic access query but could do with some help.

    I have two tables with lists of email addresses in both.

    I need to run a query that looks at both of the tables and produces a list of all the email addresses that are on both lists.

    Tables are called “All Address” and “German” with both of the columns called Email.

  • #2
    Re: Very basic Access query

    Try this SQL fragment:

    SELECT AllAddress.Email, German.Email FROM AllAddress, German WHERE AllAddress.Email=German.Email
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Very basic Access query

      Appears to have got it, thanks.

      Comment

      Working...
      X