Home  Fees/Services   Access Templates   Tutorials   Tutorial Downloads   Articles  Search  Contact  Privacy  Links
SQL Self Join Query Examples SQL Self Join  
Home > Tutorials > Query Tutorials > Self Join Query
 

 

 


Self Join

SQL Self Join Example

Access self join:  In this update query example we use the self join query technique to update each employee's salary by 10%.  There are at least two ways to do this update. Example c) (below) is supposed to work but I get errors in Access.  It is called a correlated subquery - if you can tell me what is wrong with it I'd really appreciate it.


Self Join Query Code:

a)  Update M_Emp as A INNER JOIN M_Emp as B ON A.Emp_ID = B.Emp_ID SET A.Salary = B.Salary*1.1

b)  Update M_Emp as A, M_Emp as B Set A.Salary=B.Salary * 1.1
Where A.Emp_ID=B.Emp_ID

c)  Update M_Emp as A set A.Salary = (Select Salary * 1.1 from M_Emp Where M_Emp.Emp_ID = A.Emp_ID)

Note:  I have added a another feature to this self join query example - Aliases.  Aliases are where you use 'as' to establish a short nickname for a table or a field.  This alias feature helps when you have long table names or are trying to do a correlated subquery.

Additional Self Join Examples:

Self Join in Visual Basic Detail Master Update

Table Data in Access

Access Self Join Query for Inventory Calculations Example







Contact Information

Copyright 2000-2012 Blue Claw Database Design, LLC

Query Tutorials Index:
SQL Too Complex Query
SQL Aggregate Query
SQL Not In Operator
SQL Choose Function
SQL Crosstab Query
SQL DateTime Query
SQL Delete Query
SQL External Table Query
SQL Report Filter Query
SQL Group By Query
SQL Having Query Clause
SQL Histogram Query
SQL Insert Into Query
SQL Master Detail Update
SQL Order By Query
SQL Parameter Query
SQL Predicate Query
SQL Self Join Query
SQL Scalar SubQuery
SQL Master Detail Query
SQL Select Query
SQL Select Top
SQL Union Query
SQL Update Query

MultiSelect Parameter Forms Query Tutorial