on 01-23-2015 9:51 PM
Hi,
I am merging two temp Tables by using Inner or Outer Join.
One of the table is Empty. Still query will be successful or Query Fails?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Query will not fail if there are no syntactical errors.
In your case , Inner join will not produce any record in output table , as one of your input table is empty.
Outer join result depends on the join columns and selected columns for output tables
Job will not fail.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.