I'm trying to combine these 2 SQL queries.
SELECT * FROM `history` WHERE `ID` = 56
SELECT * FROM `live` WHERE `ID` = 56 AND `ACTIVE` = 0 AND t1.`Shown` = 'complete'
I've tried doing something like this:
SELECT t1.*,t2.*
FROM `history` t1
JOIN `live` t2
ON t1.`ID` = 56 AND t1.`ACTIVE` = 0 AND t1.`Shown` = 'complete'
WHERE t2.`ID` = 56
But the query above results in selecting everything from live and forgetting about history.