Network connect to a local IP address from a static global IP address?

Is there a possible way to connect to a local SQL server on a static global IP? Let me elaborate. Assume that there is a server with a static global IP of 12.345.678.90 which refers to a certain windows based PC which in turn hosts a Microsoft SQL Server. Said server can be accessed remotely. The issue is the need to connect to another SQL server hosted on another PC on the same network with a "static local IP" of 192.168.1.100. Is there a way to connect to that server using a similar syntax to 12.345.678.90/192.168.1.100?