Database joining

 l Database joining:-

1. Joining is a special type of operation perform between 2 tables.

2. With the help of joining we get the result between multiple data.

l Joining property:-

1. Common field (column)

2. Using table object

Syntax :-  table name.column name

3. To activate joining operaton we need ON KEYWORD.

ü TYPES OF JOINING:-

1. INNER JOIN  :- Inner join returns all records from multiple data where the join condition is equal.

Ex:-CREATE TABLE invent ( id INT , name VARCHAR(20));

INSERT INTO invent values(101,'rahul'),(103,'thosar'),(102,'asus');

 

CREATE TABLE product (id INT , cost int);

 

INSERT INTO product VALUES (201,'1000'),(202,'2000'),(203,'30000');

 

SELECT invent.id , invent.name, product.cost FROM invent INNER JOIN  product  ON  invent.id =product.id;  // query for inner.

 

2. LEFT OUTER  JOIN:-(matches all the left entity.)

Ex:- SELECT invent.id ,invent.name,product.cost FROM invent LEFT OUTER JOIN product ON invent.id=product.id;

 

3. RIGHT OUTER JOIN:-

Ex:-SELECT invent.id ,invent.name,product.cost FROM invent RIGHT  OUTER JOIN product ON invent.id=product.id;

 

4. FULL OUTER JOIN :-

Ex:-SELECT invent.id ,invent.name,product.costFROM invent FULL OUTER JOIN product ON invent.id=product.id;

 

5. CROSS JOIN:- (when store procedures)

Comments

Post a Comment

Popular posts from this blog

ViewState for state management

  v  ViewState :- I.  It is used to store data value in a single webpage. II.  The ViewState cannot transfer the  data between one page to another page . v  How to create ViewState? Sytanx:- ViewState[“var”]=Control; Ex.- ViewState[“Email”]=Textbox1.text;   v  How to access ViewState data value? Syntax:-control=ViewState[“var”].Tostring(); Ex:-Label1.text=ViewState[“Email”].tostring();   Code:- using  System; using  System.Collections.Generic; using  System.Linq; using  System.Web; using  System.Web.UI; using  System.Web.UI.WebControls;   namespace  WebApplication1 {      public   partial   class   stateview  : System.Web.UI.Page     {          protected   void  Page_Load( object  sender, EventArgs e)         {        ...
Read more

INTRODUCTION OF C#

    WEB APPLICATION DEVELOPMENT(. NETframework)     1.     Frame work is a collection of tool and libraries #Dot net framework environment 1.   Solution Explore window – all types of resources, file creation , folder inside solution explore windows.   2.   Server explore window-    Only used databases.   3.   Toolbox windows –     All types of tool are provides in it (textbox, radiobutton etc).   4.   Property window -   representing all property(height, width , color).   # APPLICATION DEVELOPMENT LANGUAGE(C#)   1.C# is pure object oriented 2.C # supported web application development environment . 3. Extenxion is .c# # How to created C # Application rules     STEPS 1 file -> new -> project ->C#   -> console App(.netFramework)-> selected browse-> selected your folder -> okay. Syntax:- using Syste...
Read more