On 05/23/2015 04:33 AM, ShadowMarta at yahoo.de wrote: > Hi! > > I have made a Contentless FTS4 Table like: > > "CREATE VIRTUAL TABLE if not exists OCR USING fts4(content="", `FullOCR` > varchar;" > > And managed to insert some data into it. > > I have 2 questions: > > 1.) How to get the proper COUNT on the table ? > The only query seems to work is: > "SELECT COUNT(*) FROM OCR_docsize;" is this the right way to do it ? > > 2.) How to perform a "JOIN" operation with it? > "SELECT docid FROM OCR WHERE FullOCR MATCH 'framework';" result is "2". > > "SELECT * FROM ART INNER JOIN OCR ON ART.ID = (SELECT docid FROM OCR > WHERE FullOCR MATCH 'framework') ORDER BY ID;" > Gives "SQL logic error or missing database:" > > "SELECT * FROM ART INNER JOIN OCR_docsize ON ART.ID = (SELECT docid > FROM OCR WHERE FullOCR MATCH 'framework') ORDER BY ID;" > Gives me 9 results back - should be only 1 - > > "SELECT * FROM ART NATURAL JOIN (SELECT docid FROM OCR WHERE FullOCR > MATCH 'framework') ORDER BY ID;" > Gives me 9 results back - should be only 1 - > > What I am missing here?
Are you able to make the database file available for download somewhere? Thanks, Dan.
