#author(“2019-08-21T10:57:14+00:00”,“default:kazuma”,“kazuma”) SQL
SQL [#w49245cd]
SELECT で INNER JOIN [#l6ebfaae]
SELECT
u.id
u.mail
up.age
FROM
users as u
INNER JOIN
userprofile as up
ON
u.id = up.user_id
UPDATE で INNER JOIN [#rc4a25bc]
UPDATE
userprofile as up
INNER JOIN
user as u
ON
up.user_id = u.id
WHERE
u.mail = 'hoge@hogehoge.com'