sql - MySql to return Distinctive record -
i have written following sql statement, on test table, have 4 records , on coa_body table have 4 records, query:
select `name`, `compedia`, `specification` (`tests` t, `coa_body` cb) join `request_details` rd on `t`.`id` = `rd`.`test_id` `rd`.`request_id` = 'ndqa201303001' , cb.labref = 'ndqa201303001';
returns:
1.name compedia specification
assay alphy poxy ph(acidity/alkalinity) alphy poxy sterility alphy poxy bacterial endotoxin test alphy poxy assay poxy alphy ph(acidity/alkalinity) poxy alphy sterility poxy alphy bacterial endotoxin test poxy alphy assay alphy1 poxy1 ph(acidity/alkalinity) alphy1 poxy1 sterility alphy1 poxy1 bacterial endotoxin test alphy1 poxy1 assay poxy1 alphy1 ph(acidity/alkalinity) poxy1 alphy1 sterility poxy1 alphy1 bacterial endotoxin test poxy1 alphy1
2.coa_body table follows: id labref compedia specification
1 ndqa201303001 alphy poxy 2 ndqa201303001 poxy alphy 3 ndqa201303001 alphy1 poxy1 4 ndqa201303001 poxy1 alphy1
3.i need 4 records same coa_body table this
name compedia specification assay alphy poxy ph(acidity/alkalinity) poxy alphy sterility alphy1 poxy1 bacterial endotoxin test poxy1 alphy1
4.at end of query if add group t.name statement, returns
name compedia specification assay alphy poxy bacterial endotoxin test alphy poxy ph(acidity/alkalinity) alphy poxy sterility alphy poxy
which not want want, result want 1 @ number 3
rewriting query
select `name`, `compedia`, `specification` (`tests` t, `coa_body` cb) join `request_details` rd on `t`.`id` = `rd`.`test_id` `rd`.`request_id` = 'ndqa201303001' , cb.labref = 'ndqa201303001' group name;
Comments
Post a Comment