4 svar · 184 visningar · startad av Pace
SQL = "SELECT topic_id FROM PaceBoard_Replies WHERE reply_id = " & replyID
tmp = rs(0)
SQL = "SELECT T_Status FROM PaceBoard_Topics WHERE Topic_id = " & tmp
Hur kan man slå ihop denna SQL sats?
SQL = "SELECT T_Status FROM PaceBoard_Topics WHERE Topic_id in (SELECT topic_id FROM PaceBoard_Replies WHERE reply_id = " & replyID & ")"
Får detta felet i MySQL (fungerar bra i Access):
You have an error in your SQL syntax near 'SELECT Topic_ID FROM PaceBoard_Replies WHERE Reply_ID = 44)' at line 1
med denna koden:
SELECT T_Status, topic_id FROM PaceBoard_Topics WHERE Topic_id IN
(SELECT Topic_ID FROM PaceBoard_Replies WHERE Reply_ID = 44)
SELECT distinct pt.T_Status,pt.topic_id
FROM PaceBoard_Topics as pt
inner join PaceBoard_Replies as pr
on pt.Topic_id = pr.Topic_ID
WHERE Reply_ID = 44
mysql alltså
