SELECT P.First_Name, P.Last_Name, S.email, S.specialty
FROM tblPhysicians AS P, tblSpecialists AS S
WHERE P.License_Number = S.License_Number
My guess is that your problem is that you now get
And what you really *want* is probably something like
Or something along those lines. (Though why you would put email address into the specialty table instead of into the main physicians table is beyond me.)
So your problem has nothing to do with the JOIN, it has to do with *PRESENTATION* of the results. You mentioned "dataset", so I would guess you are using ASP.NET.
In any case, if the problem isn't just the join, re-post with some real details.