Question: two select queries shouldn't depend on each other
i want to write two select queries such that both queries shouldn't depends on each other .or how can i re-write this query? can i write this without using where, where in, where exist? or can i use AND to this query?
SELECT link_id, COUNT(*) FROM Locator GROUP BY linkid (SELECT show,actuate from Sem join class on Sem.semid = class.semid join Locator on linker.linkid=Locator.linkid);