I am geeting an invalid syntax near keyword 'INNER' error on this.
Any ideas?Code:Dim SQL2 As New SqlClient.SqlCommand("SELECT MACHINETOOL[TOOL], MACHINE[NAME] INNER JOIN MACHINETOOL[MACHINE] ON MACHINETOOL[MACHINE] = MACHINE[MACHINE] WHERE LTRIM(RTRIM(MACHINETOOL[TOOL])) = " & "'" & Trim(cboTool.Text) & "'")




Reply With Quote