Lathe Operations: Facing

Facing Operations Facing is the process of removing metal from the end of a workpiece to produce a flat surface. Most often, the workpiece is cylindrical, but using a 4-jaw chuck you can face rectangular or odd-shaped work to form cubes and other non-cylindrical shapes.

When a lathe cutting tool removes metal it applies considerable tangential (i.e. lateral or sideways) force to the workpiece. To safely perform a facing operation the end of the workpiece must be positioned close to the jaws of the chuck. The workpiece should not extend more than 2-3 times its diameter from the chuck jaws unless a steady rest is used to support the free end. Cutting Speeds

If you read many books on machining you will find a lot of information about the correct cutting speed for the movement of the cutting tool in relation to the workpiece. You must consider the rotational speed of the workpiece and the movement of the tool relative to the workpiece. Basically, the softer the metal the faster the cutting. D…

How to Join Two Tables and Print Data From Both Tables in Single Table in SQL?

I was given a task to fetch data from multiple tables and bring them to a single table so that it can be used for wider requirement. Let me give some background of the data source and the structure of data so that you can give a correct solution to it.

My office has a very wider database which is consisting of more than 200 tables in it. So, there is one primary key which is called "Code" the field name which is common in all the tables and rest all data are uncommon in all the tables.

For example:

Table 1 contains field names  "code, name, supplier, location,"

Table 2 contains field names "code, country, price, Weight, language"

Table 3 contains field names "code, mfd, expiry, batch, received"

Now I am tasked to print the fields in single table like "code, name, mfd, expiry, location, weight, price"

I have tried to do it by the "join" command but there I am unable to do it with that function. There I am able to fetch data from two table only. That also I am getting some error while fetching multiple data.

Anyhow, I have done it with the help of "MS Access" after fetching data from tables in multiple layers.

But, I want to do it in one action and want to know that exact command line/script to fetch data from multiple tables based on primary key.


Popular posts from this blog

Lathe Operations: Step Turning

Lathe Operations: Plain Turning

What Is Capstan Lathe Machine?