i have 2 table which i have to do inner join in way to display the info. however, every time i do it i will get a syntax error. i don't know how to solve it. below is the code :
<!--#include file="Connections/sambungan.asp" -->
Recordset1__MMColParam = "1"
If (Request.QueryString("caricetak") <> "") Then
Recordset1__MMColParam = Request.QueryString("caricetak")
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'staff IT.nostaffuitm'.
/systemku/TMP29ngbw1a3o.asp, line 20
When you say "INNER JOIN staff IT", That tells the server that STAFF is the tablename, and IT is the nickname you are giving it. Once you declare that, you must use Only the Tablename or the Nickname... not both.
i'have try the suggestion. what i do is i change the table name to staffIT, where u can see there is no more space or underscore.
after i do the changing, everything is ok. so, right now i know that any table's name should avoid of using space or underscore. thanks a lot for the advice. thank u everybody.........