Forum Discussion
Error When Using Left Join on 2 Different Tables
Hi Anonymous ,
The Error you are showing happens while getting connected to SQL Server. But the Creditor and Creditors column that you are displaying in your sceenshots are from Power BI which may have been replaced after importiing the data.
To have this problem resolved, you should check if this query runs in the SSMS as told by lbendlin . If SSMS cannot be used, try to verify using some other way like some document to know what exactly is the column name in the tables that you are trying to join. If the columns are there, try to see if there are any unwanted spaces before or after the column names in the databases. This also would result in an invalid object.
As the error clearly says, this issue is because of it not able to find the right columns.
Regards,
Hi Anonymous ,
The Error you are showing happens while getting connected to SQL Server. But the Creditor and Creditors column that you are displaying in your sceenshots are from Power BI which may have been replaced after importiing the data.
To have this problem resolved, you should check if this query runs in the SSMS as told by lbendlin . If SSMS cannot be used, try to verify using some other way like some document to know what exactly is the column name in the tables that you are trying to join. If the columns are there, try to see if there are any unwanted spaces before or after the column names in the databases. This also would result in an invalid object.
As the error clearly says, this issue is because of it not able to find the right columns.
Regards,