¡Hi guys!, I don't have any idea how to create a new column that contains all information of results from a Left Join if exists the value
Example
Table 1
--------------------------------------
| FieldID | FieldName | FieldAccount |
|------------------------------------|
| 01 | Jon | 12345 |
--------------------------------------
Table 2
--------------------------------------
| FieldID | FieldName | FieldAccount |
|------------------------------------|
| 01 | Jon | 12345 |
|------------------------------------|
| 02 | Charlie | 12345 |
--------------------------------------
Result
From Table 1
-----------------------------------------------
| FieldID | FieldName | FieldAccount | LookAt |
|---------------------------------------------|
| 01 | Jon | 12345 | 01,02 |
-----------------------------------------------
Field LookAt
contains the ID(s) where the FieldAccount
matches
Thanks and regards to everyone!