tag:blogger.com,1999:blog-6082652835152798567.post4718043213324426619..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Part 11 - Real time example for right joinUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6082652835152798567.post-66183985732195324722019-02-27T14:32:53.478-08:002019-02-27T14:32:53.478-08:00If we exchange the tables in the join then it can ...If we exchange the tables in the join then it can still use left join. <br />What is the use case where we need left join alone or right join alone (using the other should not be possible). srikanth vvgsnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-72185334553468869472017-06-14T04:19:57.428-07:002017-06-14T04:19:57.428-07:00since departmentid is common in both tables and th...since departmentid is common in both tables and there is a conflict so we should give departmentid from which table.But departmentname is there only in department table so no need to mention it again .Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-73319949364765473672016-10-25T23:02:08.226-07:002016-10-25T23:02:08.226-07:00hello venkat sir
In the above query we are using C...hello venkat sir<br />In the above query we are using Count(Employees.DepartmentID),If we use only Count(Employees) why is it showing error?<br />And for Select DepartmentName why isnt sql server throwing any error even if we are not using select Departments.Departmentname?<br />PLEASE HELP MEAnonymoushttps://www.blogger.com/profile/05464056902882227974noreply@blogger.com