select a.aid, b.Bid, b.Name from A a, B b, C c where c.value <> 180 and a.bId = b.Id and b.cId = c.Cid
SELECT A.aId,A.bId,B.Name FROM A INNER JOIN B ON A.bId=B.bId INNER JOIN c ON b.cId=C.cId WHERE C.value <> 180
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)