Get all data from multiple table in SQL Server

Question

I have three tablesPersonIdName1Rustam2Firuz3SuhrobFruits IdName1Apple2Orange3Cherry4MelonMixedIdPersonIdFruitsIdColor111Red212Yellow313Yellow433Red534 RegisterIdPersonIdFruitsIdColor111Red212 333Red434GreenI want get data from two table where PersonId equal Id Every day add record for people in Register must get last record not all from Register For example in bellow I show output all data for RustamOutTableIdPersonIdFruitsIdColor1RustamAppleRed2RustamOrangeYellow3RustamCherryRed4RustamOran

AnandM · Accepted Answer

Hi NuraliPlease refer below query which full fills your requirementSQLDECLARE Persons AS TABLEID INTNAME VARCHAR30INSERT INTO Persons VALUES139Rustam39INSERT INTO Persons VALUES239Firuz39INSERT INTO Persons VALUES339Suhrob39DECLARE Fruits AS TABLEID INTNAME VARCHAR30INSERT INTO Fruits VALUES139Apple39INSERT INTO Fruits VALUES239Orange39INSERT INTO Fruits VALUES339Cherry39INSERT INTO Fruits VALUES439Melon39DECLARE Mixed AS TABLEID INTPersonID INTFruitsID INTColor VARCHAR20INSERT INTO Mixed VALUES11139Red39INSERT INTO Mixed VALUES21239Yellow39INSERT INTO Mixed VALUES31339Yellow39INSERT INTO Mixed VALUES43339Red39INSERT INTO Mixed VALUES534NULLDECLARE Register AS TABLEID INTPersonID INTFruitsID INTColor VARCHAR20INSERT INTO Register VALUES11139Red39INSERT INTO Register VALUES212NULLINSERT INTO Register VALUES33339

Get all data from multiple table in SQL Server

Company

Explore

Follow us

Contact Us

Id	PersonId	FruitsId	Color
1	Rustam	Apple	Red
2	Rustam	Orange	Yellow
3	Rustam	Cherry	Red
4	Rustam	Orange

Id	Name
1	Rustam
2	Firuz
3	Suhrob