Cacher is the code snippet organizer for pro developers

SELECT pp_mfDev.positions_price_archive.pa_num, xignite.MAXDATA.TICKER as maxticker 
FROM pp_mfDev.positions_price_archive 
LEFT JOIN xignite.MAXDATA 
ON xignite.MAXDATA.TICKER = pp_mfDev.positions_price_archive.ticker 
WHERE pp_mfDev.positions_price_archive.pa_date = "2017-06-01";

// same query using table aliases
SELECT pp.pa_num, x.TICKER as maxticker 
FROM pp_mfDev.positions_price_archive pp
LEFT JOIN xignite.MAXDATA x
ON x.TICKER = pp.ticker 
WHERE pp.pa_date = "2017-06-01";

UPDATE line_items 
LEFT JOIN accounts ON accounts.accountnum = line_items.accountnum
SET line_items.processed = "2013-08-11" 
WHERE line_items.batch_num = 18 AND accounts.clinum = 6666;