What are the file names in your folder2? Are they the same as the name value? If so, this should be rather easy to do:
```dataview
TABLE name, defLink.description, qty, price
FROM "folder2"
FLATTEN link("folder1/" + name) as defLink
```
This query lists all files from folder2 (fully qualified within the vault), and uses the name to lookup the same file in folder1 and calls this link the defLink (for definition link). Then the query can use defLink.description and get its description or dimension or whatever.
If however your filenames are not the same as name, I don’t know how to do a subquery matching on just the properties being the same. I know how to do it using dataviewjs, but not in a standard query like above. In other words, I strongly suggest that file names in folder1 are either the same as name or has a given prefix so it’s easy to construct the full file name when you’ve got the name part.
See also the thread below where they’re using a translation property which is a full link, which makes such lookup even easier at the cost of a slight more cumbersome property value. (In your case you’d need to change from name: 1001 to something similar to name: "[[1001]]" )