I am presently using the following code for databinding and placing in a gridview display: 

Dim mySqlString As New StringBuilder()
mySqlString.Append("SELECT ClientName, Product, Equip, Score, Checkbox ")
mySqlString.Append("FROM {databaseOwner}{objectQualifier} MODULNAME ")
mySqlString.Append("ORDER BY ClientName DESC")
Dim myParam As SqlParameter = New SqlParameter("@SearchString", SqlDbType.VarChar, 150)
myParam.Value = SearchString
Me.GridView2.DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), myParam), IDataReader)
Me.GridView2.DataBind()

What I am wondering, is how can I add an additional column into this same gridview, which will grab from another database table?
What are all the "need to knows" for something like this?



Feedback Appreciated,

-machina12

Very Well. Appreciated.
Got it to work using the following:

("SELECT Employees.EmployeeID, Employees.FirstName, Employees.LastName, Products.Product ")
("FROM {databaseOwner}{objectQualifier} Employees, Products WHERE Employees.EmployeeID = Products.EmployeeID ")
("ORDER BY LastName ASC")

It works, but I noticed it happened to grab duplicate data. It almost seems like it is pulling double the data, expcept some of the data that has an odd number of inputs. The only thing I can figure is because the formula is looking for Employees.EmployeeID = Products.EmployeeID  ,and it may be listing twice becuase it is trying the equation both ways...still doesn't explain some of the odd numbered results.
Using: LIMIT doesn't seem to be what I am looking for either.

How would tell the sql query to only grab duplicated data once within databind? 



Feedback appreciated,

-machina12

Try this:

("SELECT DISTINCT Employees.EmployeeID, Employees.FirstName, Employees.LastName, Products.Product ")
("FROM {databaseOwner}{objectQualifier} Employees")
("LEFT OUTER JOIN Products ON Employees.EmployeeID = Products.EmployeeID")
("ORDER BY LastName ASC")