Can some one explain the SQL query for bellow outcomes in TableResult. There is two tables TableA and TableB, Function column in both tables are unique. Entire data in TableA should be there in ResultTable, If TableB Function equals in TableA function, Then ResultTable Compare column must be true otherwise it’s false. Can anyone advised How to get the desired
Tag: equals
Equals(=) vs. LIKE
When using SQL, are there any benefits of using = in a WHERE clause instead of LIKE? Without any special operators, LIKE and = are the same, right? Answer Different Operators LIKE and = are different operators. Most answers here focus on the wildcard support, which is not the only difference between these operators! = is a comparison operator that