Jump to content

DETECTIVE COMICE 1000 VARIANTS


Recommended Posts

Can you post the solution?

PS This Advanced Find can display issues that are duplicates based in Title, and Item # :

Items Where:

I.Title || I.IssueNum || I.ItemType || I.Variation || I.Printing
  IN (
      SELECT A.Title || A.IssueNum || A.ItemType || A.Variation || A.Printing
      FROM ComicIssues A
      WHERE I.Title     = A.Title
        AND I.IssueNum  = A.IssueNum
        AND I.ItemType  = A.ItemType
        AND I.Variation = A.Variation
        AND I.Printing  = A.Printing
      GROUP BY A.Title, A.IssueNum, A.ItemType, A.Variation, A.Printing (add ,I.Condition)
      HAVING COUNT(*) > 1
     )

Order By:

ComicTitles.AlphabetizedTitle, I.ItemType, I.IssueNum, I.Variation, I.Printing


If you have Multiple issues with different Conditions:

I.Title || I.IssueNum || I.ItemType || I.Variation || I.Printing || I.Condition
  IN (
      SELECT A.Title || A.IssueNum || A.ItemType || A.Variation || A.Printing || A.Condition
      FROM ComicIssues A
      WHERE I.Title     = A.Title
        AND I.IssueNum  = A.IssueNum
        AND I.ItemType  = A.ItemType
        AND I.Variation = A.Variation
        AND I.Printing  = A.Printing
        AND I.Condition = A.Condition

      GROUP BY A.Title, A.IssueNum, A.ItemType, A.Variation, A.Printing, A.Condition
      HAVING COUNT(*) > 1
     )

Order By:

ComicTitles.AlphabetizedTitle, I.ItemType, I.IssueNum, I.Variation, I.Printing

 

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...