Is this doable with just internal/left/correct join? simply because I currently attempted various combinations of inner join but it's not Doing work, such as this inner join Asset a over a.Id != as.AssetId. I occasion experimented with left and ideal join. A Unique sort of Theta-JOIN is equi JOIN, which https://charlien023iji5.wikigiogio.com/user