Tag: Database New Syllabus Solution

18. A  join operation is used to combine rows from two or more tables based on a related column between them. It is one of the fundamental operations used in relational databases for querying and retrieving data from multiple tables simultaneously. Ans:                  Select e.emp_name,e.province,e.city,b.branch,b.salary from Employee e                   Left join  Branch  b  on e.emp_name=b.emp_name;                   Select […]