https://community.sap.com/t5/application-development-and-automation-discussions/query-with-multiple-datastores/m-p/12276923#M1988377 <P>I want to delete records in Table_A in Datastore_A, based on a lookup in Table_B in Datastore_B.</P> <P>In MS SQL Server, I can span databases by specifying the database name in the query.</P> <P>In SAP DS, it appears that the query only allows 1 datastore. Is there a way to write a query spanning multiple Datastores ?</P> <P>Something like this</P> <PRE><CODE>DELETE FROM Datastore_A.Orders WHERE FiscalYear = ( select FiscYEAR from Datastore_B.DATES where (dates - 1 days) = CAST(CURRENT_TIMESTAMP AS DATE) )</CODE></PRE> <P><STRONG></STRONG><U></U><SUB></SUB><SUP></SUP> <DEL></DEL></P> Wed, 30 Sep 2020 20:51:36 GMT dunncrew 2020-09-30T20:51:36Z https://community.sap.com/t5/application-development-and-automation-discussions/query-with-multiple-datastores/m-p/12276923#M1988377 <P>I want to delete records in Table_A in Datastore_A, based on a lookup in Table_B in Datastore_B.</P> <P>In MS SQL Server, I can span databases by specifying the database name in the query.</P> <P>In SAP DS, it appears that the query only allows 1 datastore. Is there a way to write a query spanning multiple Datastores ?</P> <P>Something like this</P> <PRE><CODE>DELETE FROM Datastore_A.Orders WHERE FiscalYear = ( select FiscYEAR from Datastore_B.DATES where (dates - 1 days) = CAST(CURRENT_TIMESTAMP AS DATE) )</CODE></PRE> <P><STRONG></STRONG><U></U><SUB></SUB><SUP></SUP> <DEL></DEL></P> Wed, 30 Sep 2020 20:51:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-with-multiple-datastores/m-p/12276923#M1988377 dunncrew 2020-09-30T20:51:36Z