Thanks! We'll email you
when relevant content is
added and updated.
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 "
July 24, 2009 8:27 AM
July 28, 2009 2:41 PM