MYSQL
SELECT * FROM $sTable as p LEFT JOIN toto_game as g ON p.nGmName=g.no INNER JOIN toto_club as c ON p.nHomeTeam=c.no $sWhere ORDER BY p.no DESC LIMIT $first,$num_per_page
SELECT * FROM $sTable as p LEFT JOIN toto_game as g ON p.nGmName=g.no INNER JOIN toto_club as c ON p.nHomeTeam=c.no $sWhere ORDER BY p.no DESC LIMIT $first,$num_per_page
'SQL' 카테고리의 다른 글
| [mysql] 스키마 가져오기 (0) | 2013.09.26 |
|---|---|
| [mysql] sum에 활용 (0) | 2013.09.26 |
| JOIN, GROUP BY, BETWEEN 조합 (0) | 2013.09.26 |
| group by (0) | 2013.09.26 |
| between (0) | 2013.09.26 |