ok, I found the solution myself :D
show database db_name schema | where ColumnName contains "xxx" or ColumnName contains "yyy" | summarize make_list(ColumnName) by TableName | where list_ColumnName contains "xxx" and list_ColumnName contains "yyy"