PROC FEDSQL and PROC DS2 allow database tables to be joined together. If the joins occur locally on the client, the tables are not required to be from the same schema. However, there is a restriction if you want PROC DS2 or PROC FEDSQL to pass through those same operations to the underlying database via SQL with implicit pass-through or a SAS^® In-Database Code Accelerator. PROC DS2 and PROC FEDSQL joins inside a database require tables to be from the same schema.