Duplicates

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tempy
    #1

    Duplicates

    I am not a programmer, so please bear with me.

    I have 2 tables with part numbers on and other relevant information.

    the one list does not have duplicate numbers, but the other has
    sometimes three of the same number. The numbers are 7 digit numbers
    with a change index of 2 numbers e.g. 1234567 01.(In seperate columns)

    The list with no duplicates has the highest change index and the other
    can have 3 or even 4 different indexes. e.g.

    NO Duplicates Duplicates

    1234567-05 1234567-02
    1234567-03
    1234567-04
    1234567-05

    What i need to do is to compare the numbers and show if the the
    highest value exists on both lists.

    Could some good soul please help me out of my misery ?


    Les Stout

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • John Baker
      #2
      Re: Duplicates

      Tempy wrote:[color=blue]
      > I have 2 tables with part numbers on and other relevant information.
      >
      > the one list does not have duplicate numbers, but the other has
      > sometimes three of the same number. The numbers are 7 digit numbers
      > with a change index of 2 numbers e.g. 1234567 01.(In seperate columns)
      >
      > The list with no duplicates has the highest change index and the other
      > can have 3 or even 4 different indexes. e.g.
      >
      > NO Duplicates Duplicates
      >
      > 1234567-05 1234567-02
      > 1234567-03
      > 1234567-04
      > 1234567-05
      >
      > What i need to do is to compare the numbers and show if the the
      > highest value exists on both lists.[/color]

      tblFoo
      PartNumber
      ChangeIndex

      tblFooDuplicate s
      PartNumber
      ChangeIndex

      SELECT tblFoo.*
      FROM tblFoo, tblfooduplicate s
      WHERE (((tblFoo.PartN umber)=[tblFooDuplicate s].[partnumber]) AND
      ((tblFoo.Change Index)=[tblfooduplicate s].[changeindex]));

        Comment

        • GD
          #3
          Re: Duplicates

          Tempy wrote:[color=blue]
          > I have 2 tables with part numbers on and other relevant information.
          >
          > the one list does not have duplicate numbers, but the other has
          > sometimes three of the same number. The numbers are 7 digit numbers
          > with a change index of 2 numbers e.g. 1234567 01.(In seperate columns)
          >
          > The list with no duplicates has the highest change index and the other
          > can have 3 or even 4 different indexes. e.g.
          >
          > NO Duplicates Duplicates
          >
          > 1234567-05 1234567-02
          > 1234567-03
          > 1234567-04
          > 1234567-05
          >
          > What i need to do is to compare the numbers and show if the the
          > highest value exists on both lists.[/color]

          SELECT tblFoo.*
          FROM tblFoo, tblfooduplicate s
          WHERE (((tblFoo.PartN umber)=[tblFooDuplicate s].[partnumber]) AND
          ((tblFoo.Change Index)=[tblfooduplicate s].[changeindex]));

            Comment

            Previous template Next
            Working...