select AdminId from Employee where EmployeeId=@EmpId
select E.CompanyId,C.CompanyName from Employee E,Company C where E.AdminId =@AdminId and E.CompanyId=C.Id
SELECT e.AdminId , s.CompanyName,s.CompanyId FROM Employee e INNER JOIN Company s ON e.AdminId = s.AdminId WHERE e.EmployeeId=@EmpId
IF condition (statement) Else 'if insert returns an error' ( statement) end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)