Re: Left join syntax error

[Rich Shepard]

On Sat, 18 May 2024, Adrian Klaver wrote:

Show the complete query.

Take the error message as correct, you are specifying 'companies as c' more then once.

Adrian,

I saw that but didn't know how to specify the alias only one time.

Thanks,

Rich