Home

How do display a row just once in one to many releationship

%3CLINGO-SUB%20id%3D%22lingo-sub-813086%22%20slang%3D%22en-US%22%3EHow%20do%20display%20a%20row%20just%20once%20in%20one%20to%20many%20releationship%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813086%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20as%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmployee%20Table%3C%2FP%3E%3CP%3EId%20Name%3C%2FP%3E%3CP%3E1%20David%3C%2FP%3E%3CP%3E2%20James%3C%2FP%3E%3CP%3E3%20Steve%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProducts%20Table%3C%2FP%3E%3CP%3EId%20Product_Name%3C%2FP%3E%3CP%3E1%20Camera%3C%2FP%3E%3CP%3E1%20Mobile%3C%2FP%3E%3CP%3E2%26nbsp%3BCamera%3C%2FP%3E%3CP%3E2%20Mobile%3C%2FP%3E%3CP%3E2%20IPad%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20join%20two%20tables%20so%20that%20the%20results%20would%20be%20as%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3Eid%3C%2FTD%3E%3CTD%3EName%3C%2FTD%3E%3CTD%3Eid%3C%2FTD%3E%3CTD%3EProduce_Name%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EDavid%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3ECamera%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EMobile%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EJames%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3ECamera%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EMobile%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EIPad%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3ESteve%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
rakeshkumarmahanty
Occasional Visitor

I have a table as below. 

 

Employee Table

Id Name

1 David

2 James

3 Steve

 

Products Table

Id Product_Name

1 Camera

1 Mobile

2 Camera

2 Mobile

2 IPad

 

I want to join two tables so that the results would be as below

 

idNameidProduce_Name
1David     1Camera    
  1Mobile    
2James     2Camera    
  2Mobile    
  2IPad      
3Steve  

 

Please help 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies