I have a 2 table structure:
Table A:
RID; Name; LP
E F 1
E F 2
E F 3
E F 12
E F 152
表 B:
LP
1
2
3
12
152
...
156
157
180
itd.
Query something like:
Insert into TableA(RID, Name, LP) Values ('E', 'F', Select LP from TableB)
我希望实现以下目标:
RID; Name; LP
E F 1
E F 2
E F 3
E F 12
E F 152
E F 156
E F 157
E F 180
etc.