> >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' > >A life saver: http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg