1. To Use LeftOuterJoin to get Desired result.
2.To check data null from select Statement...
left outer join to return 0 if null value is.... Isnull(checkExpression,replacementValue)
3. Returns a character expression after converting uppercase character data to lowercase.
LOWER ( character_expression )
No comments:
Post a Comment