When would you have a table with a relationship to itself what's an example of this?

Answer 1

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.

Answer 2

It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.

If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.