Clause error...
Microsoft JET Database Engine error '80004005'The specified field 'date' could refer to more than one table listed in the FROM clause of your SQL statement.
/mode/forum/philboard_read.asp, line 32
30'sql = "SELECT replies.*, statusname, statuslevel, users.icon, users.posts, users.icq FROM (status INNER JOIN users ON status.statusid = users.status) INNER JOIN replies ON users.username = replies.by WHERE replies.root = " & id & " ORDER BY date, time"
31'Set rsReplies = Server.CreateObject("ADODB.Recordset")
32'rsReplies.Open sql, conn, 3, 3
Hvorfor får jeg fejl, og hvordan rettes den?
