gistfile1.txt

Table A

id  name
--  ----
55  Bob

Table B

value  a_id  c_id
----   ----  ----
green    55    88
acura    55    77

Table C

id  key
--  ----------------
88  "favorite color"
77  "favorite car"

I want to generate CSV from this using SQL that results in this:

id, name, favorite color, favorite car 
55, Bob, green, acura