Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rupesh.dbms@gmail.com
It is the join in which result is obtained by equating two
coloumns with same values of one table for example
emp(eno,ename,mgrno) eno is primary key and mgrno is
recursive foreign key
select e.eno,e.ename,m.mgrno,m.ename mgrname
from emp e, emp m
where m.eno=e.mgrno;
note : one table emp is replicated as m , e and then
result is obtained.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are sql objects?
Can a foreign key be null?
Can there be 2 primary keys in a table?
What is difference between ms sql and mysql?
What is trigger in sql?
What does where 1 1 mean in sql?
What are sql procedures?
What is sql entity?
What do you think about pl/sql?
Can we alter stored procedure?
Why should I use postgresql?
Define select, insert, create, delete, update, drop keywords
What is implicit cursor in pl sql?
Does a join table need a primary key?
Do prepared statements prevent sql injection?
