var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Merge SQL columns
Hi guys I have seen similar posts but just cant get what I need.
I have a table which has 2 enteries for some people. ID and Name exist for each but the info fields will have one entery.
01,Mary Lambe,AAA, ,CCC, ,
01,Mary Lambe, ,BBB , ,DDD,EEE
How can I return
01,Mary Lambe,AAA,BBB ,CCC,DDD ,EEE
ie I need to merge the 2 into one.
Hope this helps.
max(Info1) as Info1,
max(Info2) as Info2,
max(Info3) as Info3,
max(Info4) as Info4,
max(info5) as Info5
Tags for this Thread