Insert data from another database in the loop (1 post)

I just wondered if there is anybody out there who may has an idea how to do the following:
In the loop I want to call a particular product from the DB to show a small summary of the product and its details in a table like manner.

How it should work: When I edit a new post I take the auto generated ID and put it in the DB (product table). The loop should then get the usual WP post stuff (title, author). Further is should get the ID from the WP post, open and connect to the database and the table and call some particular attributes from the DB product with the same ID as the WP post.

I am new to SQL and PHP and hope that maybe somebody can gimme a hint how to implement that.