jeudi 10 mars 2016

how to solution query for SqlServer where tableA is not data select all row tableB

I Can table A is not data(full Row null) Select all row tableB . now where TableA is not data, the query is not select data

select b.price from tableA a inner join tableB b on b.idprice = a.idprice group by a.idprice, b.price having sum(tax) < b.price;

Aucun commentaire:

Enregistrer un commentaire