what is the error in my sql query i tried in so many ways but,is always showing an error like "UNclosed quotation mark after the string"
this is my query
cmd = New SqlCommand("select * from empopal o where o.empid ='" + Label4.Text + "'(select e.empcode from loandepot e where o.empid=e.empcode)""'", connection)