>>SELECT v.custid, l.custid, v.upsino, l.upsino, v.datinp, l.puldat, v.optemp, v.pktemp, l.ift, l.color; >>FROM liquid l ; >>LEFT OUTER JOIN visual v ; >>ON v.custid + v.upsino + DTOS(v.datinp) = l.custid + l.upsino + DTOS(l.puldat) ; >>WHERE l.custid = "AL100239" AND l.upsino = "0000001"; >>ORDER BY v.upsino, v.datinp >>>
> >SELECT v.custid, l.custid, v.upsino, l.upsino, v.datinp, l.puldat, v.optemp, v.pktemp, l.ift, d.hydrogen, i.aluminum ; >FROM visual v ; >RIGHT OUTER JOIN liquid l ON v.custid + v.upsino + DTOS(v.datinp) = l.custid + l.upsino + DTOS(l.puldat) ; >RIGHT OUTER JOIN dga d ON v.custid + v.upsino + DTOS(v.datinp) = d.custid + d.upsino + DTOS(d.puldat) ; >RIGHT OUTER JOIN icp i ON v.custid + v.upsino + DTOS(v.datinp) = i.custid + i.upsino + DTOS(i.puldat) ; >WHERE l.custid = "AL100239" AND l.upsino = "0000001" ; >OR d.custid = "AL100239" AND d.upsino = "0000001" ; >OR i.custid = "AL100239" AND i.upsino = "0000001" ; >ORDER BY v.upsino > >>Thanks again
SELECT v.custid, l.custid, v.upsino, l.upsino, v.datinp, l.puldat, v.optemp, v.pktemp, l.ift, d.hydrogen, i.aluminum ; FROM visual v ; RIGHT OUTER JOIN liquid l ON v.custid + v.upsino + DTOS(v.datinp) = l.custid + l.upsino + DTOS(l.puldat) AND l.custid = "AL100239" AND l.upsino = "0000001"; RIGHT OUTER JOIN dga d ON v.custid + v.upsino + DTOS(v.datinp) = d.custid + d.upsino + DTOS(d.puldat) AND d.custid = "AL100239" AND d.upsino = "0000001" ; RIGHT OUTER JOIN icp i ON v.custid + v.upsino + DTOS(v.datinp) = i.custid + i.upsino + DTOS(i.puldat) AND i.custid = "AL100239" AND i.upsino = "0000001"; ORDER BY v.upsinobut I'm not sure. Multiple table joins are very tricky, it would be easier to do it in multiple steps instead if possible and probably use LEFT JOIN instead.