SQL : plz do somthing its urgent.

[dev_rfid]

hi plz help me to solve my problem. i have two tables A and B A B ----------------------------------------------- SRNO STATUS SRNO STATUS ------------------------------------------------ 101 A 101 X 102 NULL 102 Y 103 NULL 103 Z 104 B 104 W ------------------------------------------------ I M TRYING FOR A QUERY FOR THE FOLLOWING OUTPUT : -------------------- SRNO STATUS ------------------- 101 A 102 Y 103 Z 104 B ----------------- THANKS :-):rose: -- modified at 10:01 Monday 13th February, 2006

[Colin Angus Mackay]

SELECT A.SRNO, COALESCE(A.STATUS, B.STATUS)
FROM A
INNER JOIN B ON A.SRNO = B.SRNO

COALESCE will return the first non-NULL from its parameters. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

[Daniel Santillanes]

Cool, very clean and better than my possible suggestion (case when ...) daniero