HI @Mustapha_Hadj,
Welcome to the Elastic Community.
As mentioned in doc configuring_multiple_sql_statements , You need to define separate Logstash configuration files for each statement.
Also you can achieve something using join query like this.
1 Like