Hello All,
My envinronment is SQL 2005. The data in my table is as follow:
ID Test
1 Tax Exempt
1 Tax Composition
I would like to pull only one Test for this ID. It does not matter which test. I don't have a date field or any other unique key to differentiate between the two test for this ID
select *
from student s
left join Test t
on s.ID = t.ID
result:
1 John Doe Tax Exempt
1 John Doe Tax Composition
desire result:
1 John Doe Tax Exempt
or
1 John Doe Tax Composition
Any input/suggestion is greatly appreciated. Thanks
My envinronment is SQL 2005. The data in my table is as follow:
ID Test
1 Tax Exempt
1 Tax Composition
I would like to pull only one Test for this ID. It does not matter which test. I don't have a date field or any other unique key to differentiate between the two test for this ID
select *
from student s
left join Test t
on s.ID = t.ID
result:
1 John Doe Tax Exempt
1 John Doe Tax Composition
desire result:
1 John Doe Tax Exempt
or
1 John Doe Tax Composition
Any input/suggestion is greatly appreciated. Thanks