sample join
0 views
Skip to first unread message
KyleKai
Feb 25, 2008, 1:06:35 PM2/25/08
to PHP MySQL Like RoR
Select * from mytable1
inner join mytable2 on mytable1.id = mytable2.mytable1_id
where mytable1.created >= '2008-01-01';
inner join mytable2 on mytable1.id = mytable2.mytable1_id
where mytable1.created >= '2008-01-01';
CFC
Feb 25, 2008, 7:31:00 PM2/25/08
to PHP MySQL Like RoR
SELECT [Fields]
FROM [Table and Join]
是這樣嗎？？
不管是INNER JOIN，OUTER JOIN還是LEFT JOIN RIGHT JOIN都是放在FROM子句後面？
FROM [Table and Join]
是這樣嗎？？
不管是INNER JOIN，OUTER JOIN還是LEFT JOIN RIGHT JOIN都是放在FROM子句後面？
KyleKai
Feb 25, 2008, 8:07:05 PM2/25/08
to PHP MySQL Like RoR
Reply all
Reply to author
Forward
0 new messages