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,