equvalent beewn join sql and data frame

[pseudo oduesp]

hi guys ,
it s similare  thing to do :

sqlcontext.join("select * from t1 join t2 on condition) and

df1.join(df2,condition,'inner")??????

ps:    df1.registertable('t1')
ps:    df2.registertable('t2')
thanks