Base columns and pivot eav fields
Hi!
I have a problem which I just can't get through it.
I have table A with fields ID, COLUMN A, COLUMN B and table B with columns ATTRIBUTE, RECORD_ID (represents Id from table A), VALUE.
TABLE A:
ID = 1
COLUMN A = 'test'
COLUMN B = 'test1'
TABLE B:
ATTRIBUTE = 'FIELD1'
RECORD_ID = 1
VALUE = 'D'
--
ATTRIBUTE = 'FIELD2'
RECORD_ID = 1
VALUE = 10
--
ATTRIBUTE = 'FIELD3'
RECORD_ID = 1
VALUE = 150
I would like to get result:
ID COLUMN A COLUMN B FIELD 1 FIELD 2 FIELD 3
1 test test1 D 10 150
I would be very greatfull for help.
Thank you very much,
Bojan