How to display below data using Sql Query

you'll need to join the two tables using a common field Code.

try this:

SELECT 
    M.Code,
    T.Emp1,
    T.Emp2,
    T.Emp3
FROM 
    Master M
JOIN 
    Trans T ON M.Code = T.Code;

Hi there! To display the data as described using SQL queries, you can achieve this by performing a JOIN between the "master" and "Trans" tables based on the Code field. Here's an example SQL query for your scenario:

SELECT master.Code, Trans.Emp1, Trans.Emp2, Trans.Emp3
FROM master
JOIN Trans ON master.Code = Trans.Code;

In this query:

- We are selecting the Code field from the "master" table and the Emp1, Emp2, and Emp3 fields from the "Trans" table.

- By using JOIN and specifying the condition `master.Code = Trans.Code`, we are linking the two tables based on the common field "Code".

When you execute this query, it will fetch data from the specified fields in both tables where the Code values match.

If you have actual table names and column names, make sure to replace "master" and "Trans" with your actual table names and adjust the column names accordingly.

I hope this helps! If you have any more questions or need further clarification, feel free to ask.