Your cart
  • IMG
    {{cart_item.name}}
    {{cart_item.variation_attribute_name}}: {{cart_item.variation_attribute_label}}
    {{cart_item.item_unit}}: {{ setCurrency(cart_item.price)}}
    {{ setCurrency(cart_item.price*cart_item.quantity)}}
    Invalid quantity more than stock
Total :
{{setCurrency(cart.sub_total)}}

There is no item in the cart. If you want to buy, Please click here.

Self-join

Oracle Database Basic Course

Created by :
Database, Oracle
course
Programming, Software and application
1756
2020-12-07 03:13:23

A self JOIN is a regular join, but the table is joined with itself.  A self join simply specifies that each rows of a table is combined with itself and every other row of the table.


Syntax

SELECT a.column_name, b.column_name...  
FROM table1 a, table1 b  
WHERE a.common_filed = b.common_field;