>I was under the impression that a left join would display all the records from left side and only the matches of the right.
>
>My sql is missing row number 7
>
>The wqmssrmrxr file has a tailno field and rowindex field. Records are rowindex 5 thru 27
>The wqmssrmrxl file has serialno, tailno, rowno. There is no record for rowno 7.
>
>
>
>Select rowindex, serialno From webprddt1.wqmssrmrxr" +;
>" Left Join webprddt1.wqmssrmrxl On webprddt1.wqmssrmrxl.rowno = webprddt1.wqmssrmrxr.rowindex" +;
>" And webprddt1.wqmssrmrxl.coldesig = 'L'" +;
>" Where webprddt1.wqmssrmrxr.tailno = 'YR756' And webprddt1.wqmssrmrxl.tailno = 'YR756'
>
>
Take a look at this blog post
Why LEFT JOIN doesn't bring records from the LEFT table
If it's not broken, fix it until it is.
My Blog