If you want just 1 value (any) from lookup, you can use:

SELECT
     post_processing_info, 
     (
        SELECT
            is_json
        FROM
            tables_lookup
        WHERE
            tables_lookup.content_hash=webpage_contents.content_hash
        LIMIT 1
     ) AS is_json
FROM 
     webpage_contents
WHERE 
     content_hash = 'abc' 

If you want only one value,
or

SELECT
    post_processing_info, 
    x.is_json
FROM
     webpage_contents
JOIN
     (
        SELECT 
            content_hash,
            MIN(is_json)
        FROM
            tables_lookup
        GROUP BY
            content_hash
     ) AS x ON
         x.content_hash=webpage_contents.content_hash
FROM 
     webpage_contents

if you want the full join... I'm using MIN() here as an arbitrary function
to get just one value from the group.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to