need help with subquery in calc view

Hello,

We have a need to write a sub query in the select clause like below. Assume car1 & car2 are views.

SELECT CarID, Brand, (SELECT MAX (HP) FROM Car2 c2

WHERE c2.Brand = c1.Brand) - HP AS Difference

FROM Car1 c1;

I think we can achieve this with sql statement in table functions. Just wondering if we can achieve this with graphical calculation views? If yes, please help me how to achieve?

Thanks in Advance,

Ram