i have this query
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.