SELECT * FROM T1 as a full join T2 as b on p. osition_number_id=Anderson d
If use full league when the federated query, so grammar will be an error after T1 set an alias, what's the problem

CodePudding user response:

And other errors, use oracle tried ok, oracle alias, of course, not as a keyword

CodePudding user response:

Alias table don't add the AS

CodePudding user response:

refer to the second floor sxq129601 response:

table aliases don't add the AS

without can also but this is not the crux of the problem,

CodePudding user response:

reference 1st floor iamlaosong response:

if other errors, use oracle tried no problem, of course, oracle alias without the as keyword

Don't know if other questions, but I won't complain as long as there is no aliasing, omit the as is the same error