This is a simple one .... 1

[lookup13]

I want to make list of all the Mfg from my parts table,
but the problem is how do I get one listing for each
item? For ex
part table
mfg partnumber etc
apple 123456
apple 134567
apple 145624
bike 123465
car 123468

select * [parts]
order by [mfg]asc

apple
apple
apple
bike
car

Would like
apple
bike
car

Any Ideals

 

[gmmastros]

Select Distinct mfg From parts order by mfg

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[lookup13]

Thank you,I knew it was simple...