I have two tables (A & 😎.
Table A has two fields (A_ID and NAME).
Table B has three fields (B_ID, A_ID, and COLOR)
I need to create a query that recieves all of the information in Table B (and relevant NAME's in Table A) and displays like follows... (with NAME only being displayed once per grouping that it is associated with)
NAME 1
....COLOR 2
....COLOR 6
....COLOR 4
NAME 2
....COLOR 3
....COLOR 5
....COLOR 1
I am so confused about how to create this(these?) queries, and display the information using a while loop. Any help will be greatly appreciated. Thanks.
