Answered step by step
Verified Expert Solution
Question
1 Approved Answer
We have the following tables which creates statement are create table supplier(S_NO int identity(1,1), SUP_ID varchar(50) primary key,SUP_NAME varchar (50), SUP_ADD varchar (50), SUP_NIC int,
We have the following tables which creates statement are
- create table supplier(S_NO int identity(1,1), SUP_ID varchar(50) primary key,SUP_NAME varchar (50), SUP_ADD varchar (50), SUP_NIC int, rank int)
- create table Product(Prod_ID varchar(50) primary key,Prod_Name varchar(50),[Price/Unit] float)
- create table Orders(Ord_ID varchar(50) primary key,Prod_ID varchar(50),Qty int,Totalrate int,SUP_ID varchar (50))
Write the Queries using Joins on above tables
- List of all supplier that palced order
- List of all Product that are supplied by supplier whose id is 101
- Find all order(s) of product named Rice
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started