Skip to content

Instantly share code, notes, and snippets.

@dyng

dyng/gist:5299251

Last active December 15, 2015 17:49
Show Gist options
  • Save dyng/5299251 to your computer and use it in GitHub Desktop.
Save dyng/5299251 to your computer and use it in GitHub Desktop.
Download ZIP
Inner Join 中使用 AS 的例子
Raw
gistfile1.sql
SELECT me.id, him.nickname, me.user_id, transaction_id, purchase_at FROM payment AS me INNER JOIN user AS him ON me.user_id = him.id WHERE him.nickname = 'tama';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment