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…

Read More

Types of Drives in Slotting Machine

These machines utilize three types of drives. These are rack driven, screw driven, and crank driven. The crank driven being most common because of the variety of work, which they undertake, normally. Main Parts of Slotting Machine   The various main parts of slotting machine are as mentioned below: Frame or Column. This is a massive casting of great strength designed to carry all the working part of the machine. Table. Table of slotter holds the work piece and is adjustable in longitudinal and cross-wise directions. The table can be rotated…

Read More

Types of Slotters Used in Slotting Machine

Various types of slotters are designed to suit various requirements. There are three types of slotters. (a) Puncher Slotter. The puncher slotter is a heavy, rigid machine designed for removal of large amount of metal from large forgings or castings. The length of stroke of a puncher slotter is sufficiently large. It can remove 1.5 Kg to 2.5 Kg of material in one minute. Locomotive crank webs can be slotted from the rectangular shapes to exact size in less time than by any other method. (b) General Production Slotter. This is widely…

Read More

Purpose, Importance and Functions of Slotting Machine

A Slotting machine may also be known as heavy-duty shaper. Slotting machine resembles a shaping machine in all respect except that the ram instead of reciprocating to and fro in the horizontal plane, moves up and down in the vertical plane. Therefore, the slotting machine is some times called as vertical shaper. Purpose of Slotting Machine It is very useful for making keyways, machining square holes, cutting of internal and external teeth on big gears, machining of dies, punches, etc. The job is generally supported on a round table, which has…

Read More