Click here to Skip to main content
12,627,340 members (35,564 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# Visual-Studio Access
I have One Table Like This

Id Bill_No Item_Name Article_no Category Price Supplier_name Date
1 as001 Jeans 600 Levice 1000 Manu 24/12/2011
2. as001 Jeans 600 Levice 1000 Manu 24/12/2011
3 as001 Shirt 600 Levice 400 Manu 24/12/2011
4 as002 Jeans 600 Levice 1000 Rakesh 25/12/2011
5 as002 Jeans 400 Lux 1200 Rakesh 25/12/2011

I want To Retrieve Table Like This :

Bill_no Supplier_Name Date
as001 Manu 24/12/2011
as002 Rakesh 25/12/2011

How To Do It Help Me
Posted 27-Sep-12 19:37pm
Updated 28-Sep-12 20:31pm
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

select distinct id, name from tablename

this may help you...
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi

Can you give one sample table data with your expected answer

Thanks
Mohan
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.161205.3 | Last Updated 29 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100