You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND search_table.ID = details_table.ID' at line 1SELECT * FROM search_table, details_table WHERE search_table.ID= AND search_table.ID = details_table.ID at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at SocietyWebApplication.MySqlQueryManager.PerformQuery(String query, HttpResponse response) in c:\inetpub\wwwroot\RealEstate\MySqlQueryManager.cs:line 582