select b.item1, b.item2, b.item3,
a.item1 as aitem1, a.tiem2 as aitem2, a.tiem3 as aitem3,
a.tiem4 as aitem4, a.tiem5 as aitem5, a.tiem6 as aitem6
from `tableA` a, `tableB` b
where a.end_at > 今天
and a.b_id = b.id
部份column name跟變數記得改掉
select a.* , b.*
from tablea a , tableb b
where a.b_id= b.b_id
and a.結束日> current timestamp
iThome鐵人賽
看影片追技術