troubleshooting Question

help with sql sql changes

Avatar of zolf
zolfFlag for United Arab Emirates asked on
Microsoft SQL ServerSQL
8 Comments3 Solutions276 ViewsLast Modified:
hello there,

i have this query

SELECT
ds.ip,
p.UserName,
bl.BlockID,
bl.Row,
bl.BookhtNum,
bl.TelCenterID,
bl.slot,
btl.name
FROM
dbo.Ports p INNER JOIN dbo.bookht_BookhtsList bl  
INNER JOIN dbo.bookht_telcenter btl  ON btl.pkid = bl.TelCenterID ON p.Bookht_ID = bl.pkid
INNER JOIN dbo.DSLAMS ds ON ds.ID = bl.DSLAM_ID WHERE (p.UserName like '%12345678')

which needs to be changed.now the table ports has been removed and the UserName which is the phone number has gone into another table called tel_port.how should i do it.please help.

cheers
zolf
ASKER CERTIFIED SOLUTION
Aneesh
Database Consultant
Join our community to see this answer!
Unlock 3 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros