Results 1 to 2 of 2

Thread: JOINS

  1. #1
    dee Guest

    Default JOINS

    What am I doing wrong?<BR><BR>I&#039ve JOINed two tables: SHEET1 and VOTERS at their ID.<BR>I just want to filter out from VOTERS, LIKE records from SHEET1.<BR>SHEET1 Table contains column(map_pcts) and ID, VOTERS Table contains ID, pcts, and names. How do I pull a list of voters from VOTERS where PCT contains same data as SHEET1 pct?<BR><BR>This is what I have:<BR><BR>SELECT * FROM VOTERS<BR>WHERE PCT = MAP_PCT<BR><BR>I know this is somewhat elementary.......HELP!

  2. #2
    Join Date
    Dec 1969

    Default RE: JOINS

    Try This ...<BR><BR>SELECT DISTINCT V.Names FROM Voters V INNER JOIN Sheet1 S ON V.PCT = S.Map_Pcts

Posting Permissions

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