I have created 2 tables using data from the database how can I do a le

go through below articles you will understand

https://www.c-sharpcorner.com/UploadFile/ff0d0f/joins-in-sql-server/

https://www.c-sharpcorner.com/article/easiest-way-to-understand-joins-in-sql-server/

1. SELECT column_name(s)  
2. FROM table1  
3. LEFT JOIN table2  
4. ON table1.column_name = table2.column_name;