I have two tables (simplified):
Child Table. MY_TBL1. Has column MY_VALUE, I
This table has a number of records where MY_VALUE varies.
Example of MY_TBL1:

MY_VALUE
1
2
2
1
3

Parent Table. MY_TBL2. This table have two columns, MY_VALUE, and MY_CAPT, C, 20. This table has all possible values for MY_VALUE that the child table MY_TBL1 can have. For example, MY_TBL2 could have the following rows:

MY_VALUE   MY_CAPT
1          "Caption 1"
2          "Caption 2"
3          "Caption 3"

I want to select records from MY_TBL1 and at the same time create a column for each different value of MY_VALUE. For example, the resulting cursor would have the following rows:

CAPTION_1  CAPTION_2 CAPTION_3
.T.        .F.       .F.
.F.        .T.       .F.
.T.        .T.       .F.
.T.        .F.       .F.
.F.        .F.       .T.

That is, when a row is selected from MY_TBL1 it should set the value of the column (CAPTION_1, 2, or 3) according to the value of the column MY_VALUE.

Is above possible?

Thank you.