I have two tables with a one to one relationship (T1 and T2). Example data looks like:
Expand|Select|Wrap|Line Numbers
- T1:
- Field1 Field2 (PK1 to T2)
- ----------------------------------
- 1111111 1
- 1111111 2
- 1111111 3
- 1111111 4
- 2222222 5
- 2222222 6
Expand|Select|Wrap|Line Numbers
- T2:
- Field1 Field2 Field3 Field4 (FK to T1)
- -----------------------------------------------------------------
- "Some string" "BA" 1 1
- "HUGE STRING" "BA" 0 2
- "striiiiing" Null 0 3
- Null Null 1 4
- Null Null 0 5
- Null Null 0 6
odd records, so I can't do it manually. Ideally, in the above scenario, the end result would like:
Expand|Select|Wrap|Line Numbers
- T2:
- Field1 Field2 Field3 Field4 (FK to T1)
- -----------------------------------------------------------------
- "HUGE STRING" "BA" 1 1
- "HUGE STRING" "BA" 1 2
- "HUGE STRING" "BA" 1 3
- "HUGE STRING" "BA" 1 4
- Null Null 0 5
- Null Null 0 6