I mean, that i'm loading 5 tables with 100000 to 10 000 000 rows in each table.
if i will load new data by this sql statement - it would be double data in cash. That's why - I have got info from 5 tables by first loading and thhan i guess i should manipulate this data by tools in qlikview - like expression, but not to execute another pne query with joins. Am i right or not?
Not sure if I'm following. If you're saying that, for instance, you've already got a load of docJournal, then yes, it would be inefficient to repeat that load here.
The normal approach would be to create QVDs for your two tables. Then you would do the load from the QVDs. Something like this (untested):
LOAD * INLINE [
INNER JOIN ([Table1])
"id" as "idDoc"
FROM docJournal.qvd (QVD)
WHERE exists("opDate") // done as exists instead of date check for optimized load
,count(distinct idGoods) as cnt
FROM drSales.qvd (QVD)
DROP TABLE [Table1];