Comparing multiple tables in Sqlite 3 using python:
I figured it out. I was able to do a FULL OUTER JOIN to display what is missing from one table but included in another table. 

SELECT d.type,
         d.color,
         c.type,
         c.color
FROM dogs d
LEFT JOIN cats c USING(color)
UNION ALL
SELECT d.type,
         d.color,
         c.type,
         c.color
FROM cats c
LEFT JOIN dogs d USING(color)
WHERE d.color IS NULL;