#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'