SQL Query help

Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname of person = lastname of second person?

ln phone
----------------------------------
john cubick 1223
sam course 4556

output:
john course

Interview Candidate
Oct 31st, 2007
9
1845

SQL

Answer

Showing Answers 1 - 9 of 9 Answers

Waseem Mehmood
Profile Answers by Waseem Mehmood

Nov 20th, 2007

First of all it is not valid requirment.
As per my thinking it is not possible with SQL, you can do it by using PL-SQL.

naveen.papineni
Profile Answers by naveen.papineni

Nov 26th, 2007

select first_name ,last_name ,phone_number from table where first_name in (select last_name from table )

I think this will work out.

Regards
Naveen.

geminine79
Profile Answers by geminine79

Jan 3rd, 2008

I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know.