ASP - SQL Help Using JOIN: New

I have a page where the user selects a kV and Manufacturer from tblBsh_Cross_Reference and displays list of Lapp Catalog Numbers on page as simple text, easy to do. If Lapp Catalog Number also exists in tblBsh_Bushing_Dimensions then I need number to display as hyperlink. I believe I need to use some sort of JOIN in my SQL statement, but haven't done this before. Here is page where I am testing: [login to view URL] Attached is my current code, can someone help? ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Deadline information ASAP as always. I am leaving now, but will be back at 7:00am EST. Let me know if you can help me then.