A very strange issue occurred this week that I've never seen before. I have a table with a primary key ID. I have another table with the same ID in a QVD file, and I wanted to bring some of the fields from the QVD into my table. So I did a simple left join from the QVD onto the data table, and it created hundreds of thousands of duplicate records. I thought a left join didn't create any rows, only appended columns?
In one case, it created 11M records and caused our publisher to crash. I can't for the life of me understand why a left join from a QVD would cause QV to blow up like this. I've been developing this way for years, and this is a very simple query. Does anyone have any ideas?