Hi,
I have a table with several unique entries. Let's call this table A. Each entry in table A has multiple entries in Table B. I would like to create a view that combines entries from A and B and displays them all in one row. How do i do that? Please help. Thanks.
Table A
entry 1
entry 2
entry 3
Table B
entry 1 from A entry 1 from B
entry 1 from A entry 2 from B
entry 1 from A entry 3 from B
The view I want:
entry 1 from A entry 1 from B entry 2 from B entry 3 from B