Ugrent help needed in sql

Discussion in 'Databases' started by om39a, May 2, 2011.

0
  1. #1
    Can you help me to conver this querry using the key word inner join? I have writen it using joins but I have used "=" operator for doing it.

    sql.append("SELECT ");
		sql.append("NN.CUS_ID, ");
		sql.append("NN.CONTACT_SEQ_NR, ");
		sql.append("LD.LOB_ID, ");
		sql.append("NN.PROOF_OF_BOOKING, ");
		sql.append("NN.NOTIFICATION_CON_COLLECTED, ");
		sql.append("NN.NOTIFICATION_CON_DELIVERED, ");
		sql.append("NN.NOTIFICATION_CON_DELIVERED_POD, ");
		sql.append("NN.NOTIFICATION_CON_DISPATCHED, ");
		sql.append("NN.BATCH_EMAIL_ID, ");
		sql.append("NN.BATCH_EMAIL_PREF_CD ");
		sql.append("FROM ");
		sql.append("CNRNNV01 NN, ");
		sql.append("CNRLDV01 LD ");
		sql.append("WHERE ");
		sql.append("NN.CUS_ID = LD.CUS_ID ");
		sql.append("NN.CUS_ID = ? AND");
		sql.append("NN.CONTACT_SEQ_NR = ?");
    HTML:
     
    om39a, May 2, 2011 IP
  2. om39a

    om39a Peon

    Messages:
    287
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I have done it my self. 

    sql.append("SELECT ");
        sql.append("NN.CUS_ID, ");
        sql.append("NN.CONTACT_SEQ_NR, ");
        sql.append("LD.LOB_ID, ");
        sql.append("NN.PROOF_OF_BOOKING, ");
        sql.append("NN.NOTIFICATION_CON_COLLECTED, ");
        sql.append("NN.NOTIFICATION_CON_DELIVERED, ");
        sql.append("NN.NOTIFICATION_CON_DELIVERED_POD, ");
        sql.append("NN.NOTIFICATION_CON_DISPATCHED, ");
        sql.append("NN.BATCH_EMAIL_ID, ");
        sql.append("NN.BATCH_EMAIL_PREF_CD ");
        sql.append("FROM ");
 [B]       sql.append("CNRNNV01 NN INNER JOIN CNRLDV01  LD, ");
        sql.append("ON NN.CUS_ID=LD.CUS_ID ");[/B]
        sql.append("WHERE ");
        sql.append("NN.CUS_ID = ? AND");
        sql.append("NN.CONTACT_SEQ_NR = ?");
    Code (markup):
    Thank you for trying!!!
     
    om39a, May 4, 2011 IP