ADO.Net Error: Unclosed quotation mark after the string

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)