Linking Tables on M$ Access using SQL Syntax

If you mean linking them in the Relationships Dialog, the thing that looks like an entity relationship diagram. The Relationships Dialog establishes foreign key relationships. It has no effect on joining columns in Access SQL. If you are talking about creating linked tables to a SQL Server database then I don't understand what you're asking.