Solve your biggest tech problems alongside global tech experts with 1:1 help.
SELECT a.ref, b.Col1, b.Col2, b.Col3, ...
FROM TableA a
INNER JOIN TableB b ON a.doco = b.doco
WHERE a.line = '1'
AND b.ref = '6F'
AND b.date = '2010-09-14'
Open in new window
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.