Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Project 1
create table client_master (clientno int, name varchar(20), address1 varchar(20), address2 varchar(20), city varchar(20), pincode int, state varchar(20), baldue int); create table product_master (productno int, description varchar(20), profitpercent int, unitmeasure varchar(20), qtyonhand int, reorderlvl int, sellprice int, costprice int); create table salesman_master (smanno int, smanname varchar(20), address1 varchar(20), address2 varchar(20), city varchar(20), pincode int, state varchar(20), salamt int, tgttoget int, ytdsales int, remarks varchar(20));
run
|
edit
|
history
|
help
0
Many-to-Many Join Example
tr3
manual app locks
SQL_Joins_RankingFunctions
ms sql update,insert
robot-grading
Foreign keys
persons
deepu
Task2