Please help me to make a SQL query.

Question

question

JWC asked May 29, '18

Here are two tables, table A and B.

I would like to add two columns of table A (PERSON_ID and MAIN_SICK) to table B, referring to the KEY_SEQ columns in both tables (table A and B).

Can you plz help me to build a SQL query?

I want the exactly same table like "Result".

Thank you!

query-plan

tables.jpg (220.6 KiB)

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · May 29, 2018 at 02:28 PM

What have you tried so far?

0 ·

Answer 1 · 2018-05-29T16:52:00Z

lokeshlehkara answered May 29, '18

This is simple join. I believe you are fairly new to SQL. Enjoy!!!!

SELECT A.Person_ID,A.Key_Seq,A.Main_Sick,B.Seq_No,B.Drug 
FROM 
TABLE_A as A 
INNER JOIN 
TABLE_B as B ON A.Key_Seq = B.Key_Seq

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JWC commented · May 30, 2018 at 12:37 AM

0 ·

WRBI commented · May 30, 2018 at 08:17 AM

Might be worth pointing the OP to some tutorials/MSDN around JOINS so they can learn from your example.

0 ·