A1:
ID decid decnm
1, 0001 switch
2, 0002 red lines
3, 0003 green line
4 0004 panel
A2:
ID decid pricejg
1 0001 6.0
2 0002 0.32
3 0003 0.24
Results for the following
1 0001 switch 6.0
2 0002 red line 0.32
3 0003 green line 0.24
4 0004 panel empty
CodePudding user response:
The select A1. ID, A1. Decid. A1, A2. Pricejg decnm
The from A1
Left the join A2 on A1. ID=A2. ID
CodePudding user response:
