I am trying to make an inner join get me only the results from two tables, where there is a match.
trouble is, it is bringing back all possible records, which is no use.
the first query brings back the correct results from one table
the second query has the inner join but it brings back every possible record.
brings back three rows as it should/ought to.
SELECT business_id , div_tag FROM page_blocks_to_scripts_set AS tset inner join website_scripts_to_tags AS tags on tags.script_name = tset.script_name and tags.script_name = 'mainpage' where tset.business_id = 456 and tset.live_dev = 'dev' and tset.is_equal_column = 'yes' and tset.script_name = 'mainpage'
brings back all records, seemingly, ignoring the where clause
what am I missing, please?