How to get Driving Licence without agent in Maharashtra

Go to: https://sarathi.nic.in:8443/UF/pdfforms/NewLicence.pdf

Fill and submit (only in Internet Explorer 9)

Go to: http://mahatranscom.in/NIC.aspx

click on link below:

https://sarathi.nic.in:8443/nrportal/sarathi/HomePage.jsp


Click on Print Application Form

Take print out

SQL joins

Employee

EmployeeID	Name	Telephone	StartedEmployment
1	Bob Marley	0222 00000	10/01/2005
2	John Lennon	0222 00050	02/05/2003
3	Ralph Kimball	0222 03307	01/04/2004
4	Bill Gates	0222 03307	01/04/2004

TrainingTaken

TrainingTakenID	EmployeeID	TrainingTitle	TrainingDate
1	2	Sales Training	10/01/07
2	1	Risk Management	05/02/07
3	2	First Aid	01/03/07
4	3	Sales Training	10/01/07

The Employee table has a primary key column called EmployeeID which relates to the foreign key column in the TrainingTaken table called EmployeeID.

Now that we know how these two tables relate to each other we can write a query that correctly 'joins' or 'matches' related data from these two tables. To do this we must specify in our INNER JOIN clause, the relationship between the EmployeeID column in the Employee table and the EmployeeID column in the TrainingTakentable.

Lets write a query that returns a list of employee names along with the title and date of any training they have been on.

SELECT Employee.Name, TrainingTaken.TrainingTitle, TrainingTaken.TrainingDate
FROM Employee 
 INNER JOIN TrainingTaken ON Employee.EmployeeID = TrainingTaken.EmployeeID

Returns:

Name	TrainingTaken	TrainingDate
Bob Marley	Risk Management	05/02/07
John Lennon	Sales Training	10/01/07
John Lennon	First Aid	01/03/07
Ralph Kimball	Sales Training	10/01/07

The above query demonstrates the INNER JOIN clause which specifies the two tables that we are using and then uses the ON keyword to define the relationship or 'joining points' between the two tables.

We can see that columns are identified by using TableName.ColumnName syntax so that the query knows which table to find the column we are referencing. This is because the same column name may be present in more than one table (e.g. the column name EmployeeID appears in both tables in our example).

The INNER JOIN clause in the example above can be rewritten in an alternative format (a JOIN condition) by defining the relationship between the two tables in the WHERE clause.

SELECT Employee.Name, TrainingTaken.TrainingTitle, TrainingTaken.TrainingDate
FROM Employee JOIN TrainingTaken
WHERE Employee.EmployeeID = TrainingTaken.EmployeeID

From the above example we can see that the JOIN keyword can be used as shorthand for INNER JOIN and the ON section of the INNER JOIN clause can be replaced by specifying the relationship between the two tables in the WHERE clause.

OUTER JOINS

It is important to note that the INNER JOIN Only returns data where a match is found. Therefore no information for Bill Gates was returned from this query as there is no record in the TrainingTaken table that contains Bill Gates EmployeeID.

If we wanted to return all rows from one table regardless of whether they had any related data in the table they were joining to we would need to use an OUTER JOIN.

Using table aliases for more readable queries

In order to make our queries more readable, quicker to write and debug we can use table aliases. This is where we give the table a shorthand name (after its definition in the FROM clause). We can then use this shorthand name in the rest of the query when referencing the table. Using table aliases we can rewrite our initial INNER JOIN example as follows:

SELECT E.Name, TT.TrainingTitle, TT.TrainingDate
FROM Employee E
 INNER JOIN TrainingTaken TT ON E.EmployeeID = TT.EmployeeID

In the above example we have given the Employee table an alias of E and the TrainingTaken table an alias of TT. You can see how this helps the readability of queries, especially if you have a query which had 3 or more tables joined together.

Joining more than 2 tables

We can create more than one join in a query as follows:

SELECT a.Column1, b.Column1, c.Column1
FROM TableA a INNER JOIN
 TableB b ON a.AID = b.AID INNER JOIN
 TableC c ON b.BID = c.BID
ORDER BY a.Column1, b.Column1

The same query could be rewritten as:

SELECT a.Column1, b.Column1, c.Column1
FROM TableA a JOIN TableB b JOIN TableC c
WHERE a.AID = b.AID 
 AND b.BID = c.BID
ORDER BY a.Column1, b.Column1

Conclusion

In this article we have demonstrated the concept of the INNER JOIN and how it is used to match data from related tables. We can see that the JOIN clause is an essential tool when querying well designed, relational databases. Without the JOIN clause we would not be able to define meaningful relationships between tables in our database.

We have seen how the join relationship can be specified either after the ON keyword in the JOIN clause or in the WHERE clause. We have also seen how table aliases can help make writing, reading and maintaining our SQL statements easier.

We have seen how the INNER JOIN only returns data from a table when a match is found in the other table specified in the JOIN. When data is required from one of the tables in the JOIN regardless of whether a match is found in the other table then an OUTER JOIN must be used.

Source: http://www.sqlbook.com/SQL/INNER-JOIN-37.aspx

Inspiring small story

A famous writer was in his study room. He picked up his pen and started writing :

**Last year, I had a surgery and my gall bladder was removed. I had to stay stuck to the bed due to this surgery for a long time.

**The same year I reached the age of 60 years and had to give up my favourite job. I had spent 30 years of my life in this publishing company.

**The same year I experienced the sorrow of the death of my father.

**And in the same year my son failed in his medical exam because he had a car accident. He had to stay in bed at hospital with the cast on for several days. The destruction of car was another loss.

At the end he wrote: Alas! It was such bad year !!

When the writer's wife entered the room, she found her husband looking sad lost in his thoughts. From behind his back she read what was written on the paper. She left the room silently and came back with another paper and placed it on side of her husband's writing.

When the writer saw this paper, he found this name written on it with following lines :

**Last year I finally got rid of my gall bladder due to which I had spent years in pain....

**I turned 60 with sound health and got retired from my job. Now I can utilize my time to write something better with more focus and peace.....

**The same year my father, at the age of 95, without depending on anyone or without any critical condition met his Creator.....

**The same year, God blessed my son with a new life. My car was destroyed but my son stayed alive without getting any disability......

At the end she wrote:

This year was an immense blessing of God and it passed well !!!

The writer was indeed happy and amazed at such beautiful and encouraging interpretation of the happenings happened in his life in that year !!!

Moral : In daily lives we must see that its not happiness that makes us grateful but gratefulness that makes us happy.

Think positive.....Be happy...Stay Blessed.









💀भूत-प्रेतो💀 को निमंत्रण देता है घर के
फ्रिज में रखा हुआ आटा ।

वर्तमान में बहुत सी गृहिणियां खाना
बनाते समय रात को बचा हुआ अतिरिक्त
आटा गोल लोई बनाकर उसे फ्रिज में रख
देती है और उसका प्रयोग अगले दिन करती
है। कई बार सुबह के समय भी आटा बचने पर
ऎसा ही किया जाता है। धर्मशास्त्रों
के अनुसार गूंथा हुआ आटा पिण्ड माना
जाता है जिसे मृतात्मा के भक्षण के
लिए अर्पित किया जाता है।
जिन भी घरों में लगातार या अक्सर
गूंथा हुआ आटा फ्रिज में रखने की
परंपरा बन जाती है वहां पर भूत, प्रेत
तथा अन्य ऊपरी हवाएं भोजन करने के लिए
आने लग जाती है। इनमें अधिकतर वे
आत्माएं होती है जिन्हें उनके
घरवालों ने भुला दिया या जिनकी अब
तक मुक्ति नहीं हो सकी है। ऎसी
आत्माओं के घर में आने के साथ ही घर
में अनेकों समस्याएं भी आनी शुरू हो
जाती हैं।
बचे हुए आटे को इस तरह रखने वाले सभी
घरों में किसी न किसी प्रकार के
अनिष्ट देखने को मिलते हैं। वहां
अक्सर बीमारियां, क्रोध, आलस आदि बने
रहते हैं और घर में रहने वालों की भी
तरक्की नहीं हो पाती है।
शास्त्रों के अनुसार ऎसे किसी भी
चीज को घर में स्थान नहीं देना चाहिए
जो मृतात्माओं का भोजन हो अथवा
उन्हें किसी भी प्रकार से आमंत्रित
करने की क्षमता रखती हो। इसके ही रात
के बासी बचे आटे से रोटी बनाना शरीर
के लिए भी नुकसानदेह होता है। ऎसा
भोजन तामसिकता को तो बढ़ावा देता
ही है साथ में शरीर को भी रोगों का घर
बना देता है जबकि ताजा बना भोजन शरीर
को स्फूर्ति, शक्ति और स्वास्थ्य
देता है। इन सभी चीजों को देखते हुए
हमें घर में बासी आटा नही रखना चहिये ।