hello, i wont to ask
i try to update table use from another table, i sue the left outer join
if in ms sql server this command is run, but when i try to in ms acces its cant run
please see the command
Private Sub Command31_Click()
Dim update_personallog As Integer
update_personallog = "update personallog set personallog.username= employee_master.user " _
& " from personallog left outer join employee_master " _
& "on personallog.fingerprintid = employee_master.fingerprintid "
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!