View Single Post
Old 10-25-2017, 12:18 PM   #238
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
Ok.

There's something else I don't understand,

why in one library is this the correct search:

Code:
SELECT book  FROM books_custom_column_32_link
 WHERE value IN
 ( SELECT value 
 FROM books_custom_column_32_link
 GROUP BY value 
 HAVING COUNT(*) > 1 )
and in another it's this:

Code:
SELECT book  FROM books_custom_column_9_link
 WHERE value IN
 ( SELECT value 
 FROM books_custom_column_9_link
 GROUP BY value 
 HAVING COUNT(*) > 1 )
When it's the same custom column I need to search?
Tanjamuse is offline   Reply With Quote