notin
How to write "not in ()" sql query using join
Could some one please provide how to write following sql query using joins. I do not want use not in as well as if possible I would like to replace where condition as well.[详细]
2023-02-25 06:11 分类:问答SQL NOT IN Clause
I have a query which is not working as expected Q1: SELECT id, name FROM vw_x WHERE id NOT IN (select pid from table_x)[详细]
2022-12-19 12:33 分类:问答