SELECT SQL statement problem when getting info from an accdb in VB.Net
- by Shane Fagan
Hi again all, im getting the error below for this SQL statement in VB.Net
SQLString = "SELECT AllPropertyDetails.PropertyID, Street, Town, County, Acres, Quotas, ResidenceDetails, Status, HighestBid, AskingPrice FROM AllPropertyDetails "
SQLString += "INNER JOIN Land ON AllPropertyDetails.PropertyID = Land.PropertyID "
SQLString += "WHERE…