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
