Relational DB problems

[bsachnoff]

I've been rading thrugh some posts and seem somewhat confused now. Simple example:
Data1:
id
fname
lname

employer_id

Data2:
id
employer

If want to view an entry on some fname = %b% I can see that, the lname and the emplyer_id. If I want to see the employer field also I have to make another query to Data2 based on Data1.employer_id. Is there a simpler way to do it? Secondly. If I wanted to print data1.id=7 and data2.id=3 it errors out. If I remove the "data#" then I can but it will always chose what is put in the first ID for the 2ns ID. Does this makes senses?

Obviously first attempt at some sort of relational DB's.

Thanks,

Brent

[devinemke]

lets say you want to see all info (including employer) for ID#123:

SELECT Data1.*, Data2.employer FROM Data1, Data2 WHERE Data1.employer_id = Data2.employer_id AND Data1.id = 123