I have a Sales table and a Period table. Sales table Period table I am getting the below error while I join these 2 tables. Below is the sql I used. As per my understanding, since I have given the country filter as NO in the 2nd line, it should first execute the 2nd line and then do the join
Tag: inner-query
How to express “either the single resulting record or NULL”, without an inner-query LIMIT?
Consider the following query: Assuming col1 is non-NULLable, this will yield either true or false – or possibly NULL when table1 is empty; But now suppose I have: (and assume col2 is also non-NULLable for simplicity.) If there is a unique col2 value for the lowest col1 value, or the table is empty, then this works just like before. But