Du kan ha inte . i korrelationsnamn
query = "select count(*) as antal, fp.user_id, m.username "
&_
" from forum_posts inner join members " & _
" on fp.user_id = m.id " & _
" group by fp.user_id,m.username " & _
" order by 1 desc"
Frågan#1
Har denna sql-sats:
query = "select count(*) as antal, user_id from forum_posts group by user_id order by 1 desc"
Nu vill jag även hämta från tabellen memers där id ska vara lika med user_id, har gjort så här:
query = "select count(*) as fp.antal, fp.user_id, m.username from forum_posts inner join members on fp.user_id = m.id group by fp.user_id order by 1 desc"
men den sql-frågan funkar inte, får detta felmeddelande:
Microsoft OLE DB Provider for ODBC Drivers fel '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near '.antal, fp.user_id, m.username from forum_posts inner join members on fp.user_id' at line 1
Varför?