finding rwo using key id

Posted in 2010

KARL OLIVER — Tue, 25 May 2010 20:08:13 — source: IIUG Forums & Mailing Lists

hello folks after doing a check between replicated databases uinsg the the check verbose the results come back with one row difference extra row on target <ec_ap_live_akl> key:id:17945486 How can i write a query using the key id provided to see the missing row ?

↪ replying to KARL OLIVER

KARL OLIVER — Tue, 25 May 2010 20:18:20 — source: IIUG Forums & Mailing Lists

I have just realised that id is the col name in the table

↪ replying to KARL OLIVER

KARL OLIVER — Tue, 25 May 2010 20:19:26 — source: IIUG Forums & Mailing Lists

forgot to say worked out the sql to use