Please show me how to write a unique sql statement
===

Below are the tables I need to pull data from: (I will only include columns to be used here in this example)

Maintable:

mainkey, account

1, 100

2, 200

3, 300

Childtable:

linkedkeytomain, c1,c2,c3

2, blue, null, null

2, null, black, null

2, null, null, red

My goal is to be able to write a select that will only show one line of data as below:

Account, c1, c2, c3

200, blue, black, red


Can someone please show me how to obtain this complex select. Many thanks in advance.

blumonde