Bug report #12165
Join the same table multiple times
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: |  Martin Dobias | ||
| Category: | Attribute table | ||
| Affected QGIS version: | 2.6.0 | Regression?: | No |
| Operating System: | All | Easy fix?: | No |
| Pull Request or Patch supplied: | No | Resolution: | |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 20358 |
Description
Currently, there is a limitation that a table can only be joined once. I wanted to join the same table multiple times - however, only the first join worked. All the other joined fields appear empty.
My use case:
table traffic_sign_posts (can have up to 4 different traffic signs) - has, amongst others, the following integer columns:
- sign1
- sign2
- sign3
- sign4
table traffic_signs - has the following columns:
- code (link to sign1 to sign4)
- name
- svg_symbol
- symbol_size
- symbol_offset
Now I wanted to join table "traffic_signs" 4 times to the table "traffic_sign_posts", joined with columns "sign1" to "sign4".
Associated revisions
Fix #12165 - table can't be joined multiple times
History
#1
Updated by Martin Dobias almost 10 years ago
- Status changed from Open to Closed
Fixed in changeset 68f94647fddf3b972bbc96db5a53c81fa654662f.