Join Table Issues

[jnuneznyc]

I have two tables:

First contains User_Records (FirstName, LastName, UserName) (record count: 6000)

Second contains HR_ID (HR_ID, UserName) (record count: 4000)

When I attempt a Join I get duplicate records. I want to create a new table with just the users in the HR_ID but with all the data contained in UserRecords. The extra 2000 records are not needed.

[barand]

SELECT DISTINCT firstname, lastname, username FROM
user_records u INNER JOIN hr_id h
ON u.username = h.username

hth

[dnszero]

Is there any performace difference between doing it that way and doing it this way?

SELECT u.firstname, u.lastname, u.username
FROM user_records as u, hr_id as h
WHERE u.username = h.username;

(If you have redundant data that needs to be elminated you can change the above to SELECT DISCTINCT, but that shouldn't be needed if your data is clean.)

[barand]

inner join is more efficient than just using "from a, b where .."