Project

General

Profile

« Previous | Next » 

Revision 10688

inputs/VegBank/taxonobservation_/create.sql: also join to plantname, since plantconcept.plantname may not always be populated when plantname.plantname is

View differences:

test.xml.ref
100 100
                                                                    <1>
101 101
                                                                        <_alt>
102 102
                                                                            <1>$int_currplantscifull</1>
103
                                                                            <2>$plantname</2>
103
                                                                            <2>
104
                                                                                <_alt>
105
                                                                                    <1>$plantname</1>
106
                                                                                    <2>$plantname</2>
107
                                                                                </_alt>
108
                                                                            </2>
104 109
                                                                            <3>
105 110
                                                                                <_alt>
106 111
                                                                                    <1>$Forma</1>
......
129 134
                                            <taxonomicname>
130 135
                                                <_alt>
131 136
                                                    <1>$int_currplantscifull</1>
132
                                                    <2>$plantname</2>
137
                                                    <2>
138
                                                        <_alt>
139
                                                            <1>$plantname</1>
140
                                                            <2>$plantname</2>
141
                                                        </_alt>
142
                                                    </2>
133 143
                                                    <3>
134 144
                                                        <_alt>
135 145
                                                            <1>$Forma</1>

Also available in: Unified diff