The multi-part identifier "Ijarah_id.IJARAH_REQUEST" could not be bound. Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

string query3 = "Select Ijarah_id from IJARAH_REQUEST where Ijarah_id IN(Select Ijarah_id,Installment_no,Date,Amount from SCHEDULE_OF_INSTALLMENT where Installment_no='" + txttransactionnumber.Text + "' AND Ijarah_id. IJARAH_REQUEST = '"+txtijarahid.Text+ "')";
            //MessageBox.Show(query1);
            da = new SqlDataAdapter(query3, cn);
            dt = new DataTable();
            da.Fill(dt);

            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("This Ijarah id '" + txtijarahid.Text + "' Does not Exists\n Plz first enter the record of ijarah request!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtijarahid.Focus();