I am using a join query to display data in a DGV and it goes like this:

Code:
SELECT        lnkVendorSpec.VendorSpecID,tblSupplyMaster.intSiTechID, tblSupplyMaster.strSupplierName
FROM            ((lnkVendorSpec INNER JOIN
                         tblSupplyMaster ON tblSupplyMaster.intSiTechID = lnkVendorSpec.intSiTechSupplyID) INNER JOIN
                         tblItemMaster ON tblItemMaster.intSiTechID = lnkVendorSpec.intSiTechItemID)
WHERE        (lnkVendorSpec.intSiTechItemID = ?)
There is no problem with the query and it completely fulfills it requirements. However, I have a fondness for using a double click event to select one of the rows in the display to do any of several things with the row selected. As can be seen in the query, data from two tables are contained in the SELECT command.

So what I want to do is double click on a row and in the double click event have a variable value equal to the value from lnkVendorSpec.VendorSpecID (which is an integer). I have several methods that I have used to do this in a DGV consisting of data from a single table in the SELECT, but none of them work for this. Can someone explain to me how one would obtain values from a DGV containing columns from more than one table?