format for inner join SQL query

select columns
from table t1
inner join table t2 on t1.column1 = t2.column2
inner join table t3 on t1.column1 = t2.column2
where condition


example:

"Select a.ENTITYCODE,QUERYTYPEAFFID,b.tpaname,REQUESTTYPE,STATUS,QUERYTYPE from  STATUS_QUERY_TYPE_AFF a LEFT OUTER JOIN mastertpa b ON a.ENTITYCODE = b.TPACODE where a.ENTITYCODE=?"