There are created Tables “Employee” and “Department” in “Testdb” database.
Employee
Department
The query is :
WITH
EmployeeDetail AS (SELECT * FROM [TestDb].[dbo].Employee
where Id in (1,2)
),
DepartmentDetail as(SELECT * FROM DEpartment where Id in(101,102))
SELEct * From EmployeeDetail,DepartmentDetail
Output :
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.