Inner Join Statement (A table & a query)

[VAer]

I have two tables: Table_abc Table_xyz
XyzQuery is a query from Table_xyz
I would like to set up AbcQuery which needs inner join XyzQuery

How to correct my Inner Joint statement?

Thanks.

Since SQL statement is not allowed to be posted, so I add some space inbetween.

XyzQuery = "S e l e c t Xyz_field1, Xyz_field2 f  r o m Table_xyz"

AbcQuery = "S e l e c t Abc_field1, Abc_field2 F r o m Table_abc W h  e r e Abc_field1 = " & _
        TextBoxfield1.Value & " I n n e r J o i n " & XyzQuery & " On Table_abc.Abc_field1 = XyzQuery.Xyz_field1   O R D E R   B Y Abc_field1  A S C, Abc_field2   D E S C"