question about adding another column to a sql statement -


I am starting with this table:

  SELECT [[experimental form]]. [Practice Code], [Lab Accreditation Form]. [Pre-clinical (test before)], calculation ([laboratory accreditation form]. [1 0 predefined (before test)] AS [CountOf1 0 before examining Preanalytical]] [Lab's form] Where (((([ Laboratory Form]] [Date of Date] [Forms] Between [Number]! [Lesson 4] and [Form]! [From the Number]! [Lesson 2 [])) [Lab Shape Form] By The Group. [Practice Code], [Lab Accreditation Form]. [1] Prienitical (before the trial) · Howing ((Lab Approval Letter) [Practice Code]) << "()) and (([form of lab anticipation]] [1 pre-analytical (test)))) <)>  ;  

It selects 3 columns but I must collect the comments and put them in the fourth column where the first two values ​​are the same

With MySQL, take a look at GROUP_CONCAT ().


Comments