SQL Notes
Jump to navigation
Jump to search
UPDATES from JOINS
UPDATE Document d, User u SET d.Author_FK = u.User_UD WHERE u.SF_UserId = d.AuthorId;
Multi Table SELECTs
select d.Author_FK,d.AuthorId,u.Username,u.User_ID from Document as d, User as u where d.AuthorId = u.SF_UserId;