[SQL ] SQL語法問題

[sss88340 (仲夏夜)]

name         street          city
a            aaa             bbb
b            bbb             ccc
c            aaa             bbb
d            ccc             ddd
e            eee             fff
f            ggg             hhh


我該如何選出同樣street跟city的name

篩選出 a跟c

資料庫都已經建好了只差不會篩選出來

有誰能夠幫忙一下

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 134.208.33.130
推 twoseven:SELECT * from @Table t1 WHERE (SELECT COUNT(*) FROM
→ twoseven: @Table t2 WHERE t1.street = t2.street AND t1.city =
→ twoseven:t2.city) > 1
→ sss88340:t1.street那邊顯示錯誤
推 cloudsan:顯示什麼錯誤也要提一下呀~