|
Subject:
|
question about distictrow KEY word
|
|
Posted By:
|
bbqlee
|
Post Date:
|
8/29/2006 8:53:49 AM
|
I have a table called tblTreatmentsComparison:
tblTreatmentsComparison:
ID Treatment_ID_1 Treatment_ID_2 Outcome ID
3 Adalimumab 20mg Adalimumab 40mg Zspare1
3 Adalimumab 20mg Adalimumab 40mg Zspare1
10 Iglish 10mg Iglish 10mg Zspare2
10 Iglish 10mg Iglish 10mg Zspare2
I use the following sql statement to retrieve all the unique row from tblTreatmentsComparison.
select distinctrow * from tblTreatmentsComparison
But it seems not ok. Anyidea? Thank you
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
8/29/2006 10:54:26 AM
|
Hi,
Try getting the query working in the designer, and then switch to SQL view and copy the code. I think you will find ANSI 89 at least uses "SELECT DISTINCT..."
HTH
mmcdonal
|
