Printable View
I keep on getting a 'syntax error in FROM clause' from the SQL querie below.
strSQL = "Select CALIBRECORDS1.*, gauges.instrumentdescription FROM CALIBRECORDS1 join guages on CALIBRECORDS1.instrumennumber=guages.instrumennumber WHERE CALIBRECORDS1.instrumennumber=" & "'" & Form3.Text49.Text & "'"
Anyone know where the problem is ?
Any input would be appreciated.
How about "Select * from CALIBRECORDS1 ...
i'm linking 2 tables via the instrumennumber key field.
What database are you using?
hi, i am using the access dbase
Try to build a new query and get the sql behind it.
In Access, unlike Sql Server, the word Inner is required.
CALIBRECORDS1 Inner Join guages
Or Left (depending on what you want to return...)
See top thread on sql info...
Vince