multiple table joins

Entity Creation:

 create table product(
pid int identity,
p_name varchar(200),
CONSTRAINT product_pk PRIMARY KEY (pid)
   )
create table purchase(
pid int primary key identity,
p_quantity varchar(200),
CONSTRAINT purchase_pk PRIMARY KEY (pid)
    )
create table sales(
pid int primary key identity,
p_amount decimal(18,2),
CONSTRAINT sales_pk PRIMARY KEY (pid)
  )
Foreign Key Relation:

 use SalesDb
alter table purchage add
constraint purchase_fk foreign key(pid) REFERENCES product(pid);
alter table sales add
constraint sales_fk foreign key (pid) REFERENCES product(pid);

 joins the tables:

select product.pid,product.p_name,sales.p_amount,purchase.p_quantity from  product
inner join purchase on product.pid = purchage.pid
inner join sales on product.pid = sales.pid

view creation:

 create view joinsview as
select product.pid,product.p_name,sales.p_amount,purchage.p_quantity from  product
inner join purchage on product.pid = purchage.pid
inner join sales on product.pid = sales.pid
select *from joinsview

Comments

Post a Comment

Popular posts from this blog

Angular UI Grid To Bind JSON Data

Image
1.Index.html <!doctype html> <html ng-app="app">   <head>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular.js"></script>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular-touch.js"></script>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular-animate.js"></script>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular-resource.js"></script>     <script src="http://ui-grid.info/docs/grunt-scripts/csv.js"></script>     <script src="http://ui-grid.info/docs/grunt-scripts/pdfmake.js"></script>     <script src="http://ui-grid.info/docs/grunt-scripts/vfs_fonts.js"></script>     <script src="http://ui-grid.info/release/ui-grid-unstable.js"></script>     <link rel=...
Read more

Difference between ASP.NET MVC and ASP.NET Web API

Image
Asp.Net Web API VS Asp.Net MVC Asp.Net MVC is used to create web applications that return's both views and data but Asp.Net Web API is used to create full blown HTTP services with easy and simple way that returns only data not view. Web API helps to build REST-ful services over the . NET Framework and it also support content-negotiation(it's about deciding the best response format data that could be acceptable by the client. it could be JSON,XML,ATOM or other formatted data),  self hosting which are not in MVC. Web API also takes care of returning data in particular format like JSON,XML or any other based upon the Accept header in the request and you don't worry about that. MVC only return data in JSON format using JsonResult. In Web API the request are mapped to the actions based on HTTP verbs but in MVC it is mapped to actions name. Asp.Net Web API is new framework and part of the core ASP.NET framework. The model binding, filters, routing and others MVC f...
Read more

String split equal parts and reverse the string in c#

          C# Console Application:             string name;             name = Console.ReadLine();//string             int mid = name.Length / 2; //get the middle of the String             String[] parts = { name.Substring(0, mid), name.Substring(mid) };             string reverse = new string(parts[0].Reverse().ToArray());             string reverse2 = new string(parts[1].Reverse().ToArray());             Console.WriteLine(parts[0]); //first string             Console.WriteLine(parts[1]); //second string             Console.WriteLine(reverse);//frist reverse string             Console.WriteLine(reverse2);//second reverse string        ...
Read more