0

i have 2 database

database 1: AA with table MEN

database 2: BB with table MEN

i need to run query that look for the same Fname and Lname

that has in AA.MEN and BB.MEN

how to do it ?

Improve this question

2 Answers 2

Reset to default
2 
SELECT Fname, Lname FROM AA..MEN
INTERSECT
SELECT Fname, Lname FROM BB..MEN
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

How about this?

SELECT *
FROM AA..MEN
WHERE EXISTS
(
    SELECT *
    FROM BB..MEN
    WHERE BB..MEN.Fname = AA..MEN.Fname
        AND BB..MEN.Lname = AA..MEN.Lname
)
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.