I have 2 tables "Lead" and "Deal"
the join on them is leadid
lead has fewer than deal
So what I want is an output of id from lead, and multiple rows, multiple columns strung togther from deal
id dealid status rcvd
1234 2310 Dropped 2011-01-01
1234 3254 InProc 2011-12-01
1234 (2310/Dropped/2011-01-01), (3254/InProc/2011-12-01)