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.
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)
加载中,请稍侯......