+ }
+ else {
+ PreparedStatement st = conn.prepareStatement("SELECT ReferenceNumber, "
+ + "Description, BillDate, BillAmount, ClientName"
+ + " FROM legalnotices INNER JOIN clients ON ClientId=clients.id "
+ + "WHERE BillStatus='AWAITING PAYMENT' AND ClientId=?;");
+ st.setInt (1, clientid);
+ rs = st.executeQuery();
+ }