"select * from TBL_comc as a inner join TBL_comcP as b on a.click_ID=b.click_ID " & _
" inner join TBL_com as c on b.CBC=c.CBC where c.CTypeID='" & CmbComType.Text & _
"' order by a.stat_date desc"
" inner join TBL_com as c on b.CBC=c.CBC where c.CTypeID='" & CmbComType.Text & _
"' order by a.stat_date desc"
" inner join TBL_com as c on b.CBC=c.CBC where c.CTypeID='" & CmbComType.Text & _
"' order by a.stat_date desc"
inner join TBL_comcP b on a.click_ID=b.click_ID
inner join TBL_com c on b.CBC=c.CBC
where c.CTypeID='" & CmbComType.Text & "' order by a.stat_date desc"最好不用*來代替所有字段,你用哪個字段要具體指明出來。如果三個的有相同的字段名,你用*來代替肯定出錯。