Using this database:

TABLES:

Slsrep

SLSRNUMB SLSRNAME SLSADDR TOTCOMM COMMRATE

--------- ---------------- ---------------------- --------- ---------

3 MARY JONES 123 MAIN,GRANT,MI 2150 .05

6 WILLIAM SMITH 102 RAYMOND,ADA,MI 4912.5 .07

12 SAM BROWN 419 HARPER,LANSING,MI 2150 .05

Customer

CUSTNUMB CUSTNAME CUSTADDR CURRBAL CREDLIM SLSRNUMB

--------- ---------------- ---------------------- --------- --------- ---------

124 SALLY ADAMS 481 OAK,LANSING,MI 418.75 500 3

256 ANN SAMUELS 215 PETE,GRANT,MI 10.75 800 6

311 DON CHARLES 48 COLLEGE,IRA,MI 200.1 300 12

315 TOM DANIELS 914 CHERRY,KENT,MI 320.75 300 6

405 AL WILLIAMS 519 WATSON,GRANT,MI 201.75 800 12

412 JANET ADAMS 16 ELM,LANSING,MI 908.75 1000 3

522 MARY NELSON 108 PINE,ADA,MI 49.5 800 12

567 JOE BAKER 808 RIDGE,HARPER,MI 201.2 300 6

587 JUDY ROBERTS 512 PINE,ADA,MI 57.75 500 6

622 DAN MARTIN 419 CHIP,GRANT,MI 575.5 500 3

Order

ORDNUMB ORDDTE CUSTNUMB

12489 02-JAN-00 124

12491 02-JAN-00 311

12494 04-JAN-00 315

12495 04-JAN-00 256

12498 05-FEB-00 522

12500 05-FEB-00 124

12504 06-FEB-00 522

Ordlne

ORDNUMB PARTNUMB NUMBORD QUOTPRCE

12489 AX12 11 14.95

12491 BT04 1 402.99

12491 BZ66 1 311.95

12494 CB03 4 175

12495 CX11 2 57.95

12498 AZ52 2 22.95

12498 BA74 4 4.95

12500 BT04 1 402.99

12504 CZ81 2 108.99

Part

PARTNUMB PARTDESC UNONHAND ITEMCLSS WREHSENM UNITPRCE

---- ---------- --------- -- --------- ---------

AX12 IRON 104 HW 3 17.95

AZ52 SKATES 20 SG 2 24.95

BA74 BASEBALL 40 SG 1 4.95

BH22 TOASTER 95 HW 3 34.95

BT04 STOVE 11 AP 2 402.99

BZ66 WASHER 52 AP 3 311.95

CA14 SKILLET 2 HW 3 19.95

CB03 BIKE 44 SG 1 187.5

CX11 MIXER 112 HW 3 57.95

CZ81 WEIGHTS 208 SG 2 108.99

I need to Display the sales rep name, sales rep phone number, customer name that belongs to each sales rep and the orderID and order date for each customer. I need to join three tables using the EXPLICIT INNER JOIN SYNTAX.

Thank you in advance.