SELECT * FROM TR_PO_MASTER WHERE PO_CODE ='PO069/20/0083' SELECT * FROM TR_PO_PAYMENT WHERE PO_ID =(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/20/0083')