I have two tables with different columns.
lets say there is p_Id in table one and q_id in table two.
lets say that p_id is the reference and most of them are unique.Hence want to the resultant table to have the columns where p_id is not equal to q_id( even the duplicate q_ids should not be in the end table)
How can i compare them? I want to do them only with the IF conditions as i have some other operations to be performed on basis of IF