Abraham,

Try this:


	SELECT *
	FROM Inventory
	WHERE ProdID IN
	(SELECT DISTINCT ProdID FROM Inventory)


Regards,
Rommel


-----Original Message-----
From: Abraham Luna [mailto:abe@a...]
Sent: Wednesday, October 23, 2002 12:52 PM
To: professional vb
Subject: [pro_vb] sql query language help


select distinct(prodid) from inventory

will return only 1 column of information. how do i get it to return multiple
columns of information? thanks for your help


---------
i'm using visual studio .net on windows 2000 pro


---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills
from Visual Basic 6 to C#, the language of choice
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059