var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Simple Update sql
I have 2 tables they are exactly the same, I want to set the Fillcontacts id = the contacts id. (this is the only data missing) The Invid will be the same in each table and the phone also.
When i try my sql in access i am propted for Contacts.Idcont as if it were a paramater.
UPDATE FillContacts SET FillContacts.idCont =Contacts.idcont
WHERE (((FillContacts.InvId)=Contacts.invid) AND ((FillContacts.phone)=Contacts.phone));
btw why doesnt this work in acces when it would in sql serv?
You might try:
UPDATE FillContacts INNER JOIN Contacts
ON FillContacts.InvId = Contacts.invid
AND FillContacts.phone = Contacts.phone
SET FillContacts.idCont = Contacts.idcont;