Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
update fdd1 set fdd1.Prior_Open = fdd2.Day_Open, fdd1.Prior_Close = fdd2.Day_Close from full_daily_data fdd1 inner join full_daily_data fdd2 on fdd2.Trade_Date = DATE_SUB(fdd1.Trade_Date, INTERVAL 1 DAY);
on fdd2.Trade_Date = DATE_SUB(fdd1.Trade_Date, INTERVAL 1 DAY);
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.