m00nbeast 0 Newbie Poster

Hi you wonderful helpers who generously give your time away to help the less competent :)
I thought this would be an easy task but I'm not an advanced SQL guy and don't know how to use an inner join, which apparently I need to use.
I have two tables
tblEmp
fname (text)
lname (text)
balance (money)
beginning_balances
fname (text)
lname (text)
balance (money)
I want to update the balances from beginning_balances to tblEmp.
Here's my attempt to recreate the example I was tyring to follow which yeilded zero results although I know that there are exact fname and lname matches:

Update tblemp
Set    tblemp.balance = beginning_balances.balance
From   tblemp
       Inner Join beginning_balances
         On tblemp.fname = beginning_balances.fname
         And tblemp.lname = beginning_balances.lname
Where  tblemp.balance = 0

Am I completely off here?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.