Hello, I'd like to starting my question by thanking anyone who might have any insight on my problem and is willing to help.
I have a Flow in Power Automate Desktop where I connect to a SQL Database and extract data from 2 different select statements.
The first one returns me a database containing 3 columns: id_func , name and cellphone_number and looks like this:
select id_func,name,cellphone_number
from tb_funcionario
The second one returns only two columns: product_number and id_func.
select product_number,id_func
from tb_dist
Then, I'm running another SQL statement where I'm trying to join both of them:
select * from %Fist_Select%
left join %Second_Select%
on ([%%Fist_Select%].id_func) = ([%Second_Selec%].id_func)
But I'm getting the following error:
Error in SQL statement The identifier that starts with '[...]' is too long. Maximum length is 128.
Incorrect syntax near 'data'.
I'm thinking that the problem might be in syntax, but every other sample of code that I've seen is similar to mine. Help please
PS: First question in here so, forgive me for anything different from the "normal" way to ask.
