Hi All,(adsbygoogle = window.adsbygoogle || []).push({});

Hope this is not too simple/dumb. I think I have a good idea of what an inner join of two SQL tables T1, T2 along a common field F is, but , for an exercise, I am looking for a precise definition. I am looking for a definition of this sort: (please correct if necessary or let me know if this is right)

Inner Join function of relational tables T1, T2 along a common column F:

It is a function that takes as inputs a pair T1, T2 of tables and spits out a table T3 so that:

1) F does not appear in T3.

2) T3 contains as columns : all columns other than F that are either in T1 or in T2 (or both). Each of these appears exactly once in T3.

Is this right?

Thanks.

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Formal Definition of Inner Join?

Tags:

Loading...

Similar Threads - Formal Definition Inner | Date |
---|---|

Definition and alternatives for Von Neumann architecture? | Sep 24, 2016 |

[SQL Server] Object Definition | Aug 26, 2016 |

Question on declaration and definition | Feb 25, 2016 |

Help to write a psudoecode (formal) of this procedure. | May 13, 2015 |

Application of formal methods | Jun 21, 2008 |

**Physics Forums - The Fusion of Science and Community**