Help me. Problem with query

[EDN Admin]

I have 2 table. and i want to make function INSERT in VB 2010. but i want to do is, when i click button ADD.. so the data of StaffNo and Password will be updated in table login and profile
first table (login)
StaffNo
Password

Second Table (Profile)
StaffNo
Password
StaffName
Department
Email
Phone
Home Address

so i try use this query code

<pre class="x_x_default x_x_prettyprint x_x_prettyprinted" style="padding:5px; border:0px; font-size:14px; vertical-align:baseline; background-color:#eeeeee; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; width:auto; max-height:600px <code style="margin:0px; padding:0px; border:0px; font-size:14px; vertical-align:baseline; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif <span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent insert <span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b into<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent newtable
<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b select<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Login<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent value1<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ,<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Profile<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent value1
<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b from<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Login<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 , Profile<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b where<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent table1<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent StaffNo <span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 =<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent table2<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent StaffNo[/code][/code]

but when i executed query it says that have an error.. can you help me to fix this problem? what wrong with my query code?
<br/>

View the full article