I HAVE THE FOLLOWING SELECT STATEMENTS. WHEN I TRIED TO JOIN THEM, I DIDN'T GET THE EXPECTED RESULTS.....
SELECT TP.INVOICE, TP.FNAME, TP.LNAME, TB.INVOICE, TB.CITY, TB.STATE
FROM dbo.NAMETABLE AS TP WITH (NOLOCK) INNER JOIN
dbo.ADDRTABLE AS TB WITH (NOLOCK) ON TP.IDNO = TB.IDNO
SELECT PH.INVOICE, PH.PHONE
FROM dbo.PHONETABLE AS PH
THE RESULTS I AM GOT WERE:
INVOICE FNAME LNAME PHONE CITY STATE
1234567 JOHN DOE (111)000-9999 ANYTOWN MA
1234567 JOHN DOE (111)000-9999 ANYTOWN MA
1234567 JOHN DOE (111)000-9999 ANYTOWN MA
2345678 JOHN DOE (000)123-4567 ANYTOWN MA
2345678 JOHN DOE (000)123-4567 ANYTOWN MA
2345678 JOHN DOE (000)123-4567 ANYTOWN MA
3456789 JOHN DOE (222)000-1111 ANYTOWN MA
3456789 JOHN DOE (222)000-1111 ANYTOWN MA
3456789 JOHN DOE (222)000-1111 ANYTOWN MA
THE RESULTS I WANT ARE:
INVOICE FNAME LNAME PHONE CITY STATE
1234567 JOHN DOE (111)000-9999 ANYTOWN MA
1234567 JOHN DOE (000)123-4567 ANYTOWN MA
1234567 JOHN DOE (222)000-1111 ANYTOWN MA
2345678 JOHN DOE (111)000-9999 ANYTOWN MA
2345678 JOHN DOE (000)123-4567 ANYTOWN MA
2345678 JOHN DOE (222)000-1111 ANYTOWN MA
4567890 JOHN DOE (111)000-9999 ANYTOWN MA
4567890 JOHN DOE (000)123-4567 ANYTOWN MA
4567890 JOHN DOE (222)000-1111 ANYTOWN MA
Sorry about the all caps.....anyway, I am very much a beginner when it somes to joins, etc....How can I joins these 2 statements and get the desired result?
Start Free Trial
