sql error in statement (resolved - part 2)

[fenster]

Im breaking my problem down in an attempt to get it solved..



i have a table customer ... primary key cust.id
i have a table job ..............primary key job.id and has field cust.id
i have a table transaction..primary key trans.id and has field job.id

on that basis is this bit of sql code ok?

    strSQLString = strSQLString & " FROM"
    strSQLString = strSQLString & " Customer"
    strSQLString = strSQLString & " Inner JOIN"
    strSQLString = strSQLString & " Job ON Customer.CustID = Job.CustID"
    strSQLString = strSQLString & " INNER JOIN"
    strSQLString = strSQLString & " [Transaction] ON Job.jobID = Transaction.jobID"

error:

missing operator in query expression 'Customer.CustID = Job.CustID INNER JOIN [Transaction] ON Job.jobID = Transaction.jobID'


davie


just needed () round the first inner join.....