select a.first_name, a.last_name, a.city, a.state, b.city, b.state
from tbl_a a, tbl_a b
where a.first_name = b.first_name and
a.last_name = b.last_name _________________ Regards,
Programmer
Select
A.FIRST_NAME,
A.LAST_NAME,
A.CITY,
A.STATE,
B.CITY,
B.STATE
from
(SELECT * FROM TBL_A D WHERE EXISTS (SELECT FIRST_NAME,LAST_NAME,MAX(TITLE) FROM TBL_A E WHERE D.FIRST_NAME=E.FIRST_NAME AND A.LAST_NAME=E.LAST_NAME
GROUP BY FIRST_NAME,LAST_NAME
HAVING MAX(TITLE)=D.TITLE )
) AS A
,
TBL_B
WHERE
A.FIRST_NAME=B.FIRST_NAME
AND A.LAST_NAME=B.LAST_NAME
AND A.TITLE^=B.TITLE
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
