Posts by Dexter • 1 point

• -1

  votes

  2

  answers

  87

  views

  Q: SQL + Left Join

  I have 3 tables produto, carrinhoProduto and venda I wanted to know the products that did not sell in the year 2015: SELECT p.idProduto,p.descricao as 'Produto',datepart(year,v.dataVenda) as 'Ano'…

  sql

  asked 8 years ago Dexter 1