SQL Notes

From PeformIQ Upgrade
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;