sql cte to join two results in one common

thanks @KalpeshSachdev this works good

I cant use it because i am not selecting from a table directly instead i have a function which makes a single column table and returns the output