Need help with an SQL Statement

[Eric]

Ok. I have two tables.

tblEmployee
tblTelephone

Telephone relates to the Employee. There can be multiple telephone numbers per employee.

Here is what I need:

Every employee record, and the FIRST telephone number for that employee.

My brain isn't working well this morning... I think it's the rain.

[bdi]

When you say first telephone number do you mean the first one that comes up in the database? First one alphabetically? Or do you have a priority on them?

Just to assume priority

[Eric]

Thanx Josh! I knew someone here would have an answer. I'll put that to work.

I have a priority on the fields, so that will work.