One more thing on multiple tables and sql

[1712]

The following is the code for trying to get data from a related table using sql statements.

sqlstr = "SELECT * FROM nanny inner join references on nanny.id = references.id"
sqlstr = sqlstr & " WHERE nanny.id = " & request("id&quot


I get a syntax error on the execution of this statement saying I have an error on the from statement.

 

[vbkris]

do a response.write before execution of query:
response.write sqlstr

' what does it display?

Known is handfull, Unknown is worldfull