Here is correct syntax
Re: Syntax error Thread #
1247986 Message #
1248330and it seems I was correct. It was just a typo.
DELETE tPrinters from tPrinters LEFT JOIN ptTemp T on UPPER(tPrinters.Nome) = UPPER(T.nome) where T.Nome is NULL
>I realize that when I stop thinking and go walking than solutions appear in my mind
>Yet, I insist in stay long non-stop hours working
>
>About your code below, I have a message error
>
>"Object tPrinters not found"
>
>Sorry if I seem lazy, but I am really not used to SQL
>
>
>DELETE tPrinters from tPrinters LEFT JOIN ptTemp T on UPPER(tPrinters.Nome) = UPPER(T.nome) where T.Nome is NULL
If it's not broken, fix it until it is.
My Blog