SQL Server - 在不使用UNION子句的情况下从单独的表中检索数据

I have a problem and not sure if there is even a possible solution, however still thought to raise it in this forum as there are some masters here who might be able to provide some solution :)I have a problem and not sure if there is even