var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: need help with modify entry
I have performed nested query to find out the ssn of a lawyer.
( SELECT ...
And then I want to update the lawyer table (I am restricted to use only 1 exec) by this ssn that I just got from the query. So i type
SET ssn = L.ssn
WHERE ssn = L2.ssn;
L, L2 are defined in the nested queries
but I can't make this compile?
Can anyone tell me what's wrong?
(I don't exactly know generally how you update the entries in a table after performing queries, I am new to sql)