Small Part of the Instructor Table
--------------------------------------------------
Instructor_ID Salutation First Last Street Address Zip
101 Mr Fernand Hanks 100 East 87th 10015
102 Mr Tom Wojick 518 West 120th 10025
103 Ms Nina Schorin 210 West 101st 10025
104 Mr Gary Pertez 34 Sixth Ave 10035
105 Ms Anita Morris 34 Maiden Lane 10015
106 Rev Todd Smythe 210 West 101st 10025
107 Dr Marilyn Frantzen 254 Bleeker 10005
108 Mr Charles Lowry 518 West 120th 10025
109 Hon Rick Chow 56 10th Avenue 10015
110 Ms Irene Willig 415 West 101st (null)
------------------------------------------------------------------
Small Part of the Student Table
152 Mr. Thomas Edwards 501 W. Elm 07036
157 Ms. Shirley Jameson 101 Daniel St. 07008
158 Mr. Roy Limate 5 Horizon Rd. 07024
159 Mr. Thomas Edwards 45 Maplewood Ave. 07040
160 Mr. John T. Beitler 100 Plaza Dr, ITT CSI Emp. Dpt 07096
168 Ms. Sally Naso 812 79th St. 07047
182 Mr. Jeffrey Delbrun PO Box 1091 07024
185 Mr. Dennis Mehta 371 Monmouth St. 07302
186 Ms. Christine Sheppard 16 Seymour St. 07042
187 Mr. O. Garnes 125 Great Hills Rd 07078
Small Part of the Instructor Table
------------
阅读背景：
SQL语句只显示来自两个不同表的重复邮政编码
来源：互联网
分享到：
