SQl query

Question

Consider the relation Customers (custid, name , address , city , state , introducer)

List all the customers who have introduced at least one other customer

1) Select distinct e.name from Customer e, Customer F where f.introducer =e.ename

2) Select distinct e.name from Customer e, Customer F where f.introducer <>e.name

Answer 1

1 should work.

Comments

i stil think A as answer only !

---

Yes. It should be. 1 should be correct. "Self Introduction" is not a usual procedure.

---

NO , if we consider self introduction case then second one will be correct