CanonTG Posted March 3, 2014 at 03:31 PM Report #547359 Posted March 3, 2014 at 03:31 PM (edited) Boas, Inicialmente tinha a seguinte query select v.*, c.nomeComercial from visitas v,clientespotenciais c WHERE v.nCliente = c.nCliente and v.estado = 0; por uma questão de optimização criei esta mas dá erro de syntax select v.*, c.nomeComercial from visitas v, select (nCliente, nomeComercial from clientespotenciais) c WHERE v.nCliente= c.nCliente and v.estado = 0; Edited March 3, 2014 at 03:32 PM by CanonTG
Kline777 Posted March 3, 2014 at 03:38 PM Report #547361 Posted March 3, 2014 at 03:38 PM (edited) Nao podes por assim 2 querys separadas por virgulas... Nao quererás usar um join? select v.*, c.nomeComercial from visitas v left join clientespotenciais c ON v.nCliente = c.nCliente where v.estado=0 Edited March 3, 2014 at 03:41 PM by Kline777 2 Report
CanonTG Posted March 3, 2014 at 03:44 PM Author Report #547363 Posted March 3, 2014 at 03:44 PM Sim era mesmo isso, obrigado 🙂
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now