Connected Successfully!!!
SELECT acr.conrem_id, ac.autocon_id, acr.rem_id, acr.conrem_sender_name, acr.conrem_sender_email, acr.conrem_cc, acr.conrem_replyto, acr.conrem_subject, acr.conrem_content, acr.conrem_exstd, acr.conrem_pendstd, ac.auto_id, ac.autocon_batch, ac.autocon_keydate, acr.conrem_days, acr.conrem_location, acr.conrem_qualification, acr.conrem_classification, acr.conrem_scat_ids, acr.conrem_mode_of_learning FROM auto_controller_remainder acr, auto_controller ac WHERE acr.autocon_id=ac.autocon_id AND acr.conrem_id !='' AND acr.autocon_id='2239' AND acr.conrem_pendstd!='' AND ac.status='A' AND acr.status='PN' GROUP BY acr.conrem_id