Combining two SQL query commands

Question

I want to query two databases. I want all fields from db1 and one more field from db2.

The command is like this:

select name from db2 where id in (select id from db1 where date > '2018-1-1')

Then I need to query db1 for all the fields again.

select * from db1 date > '2018-1-1'

How to combine these two queries?

Gordon Linoff · Accepted Answer · 2018-01-09 04:12:31Z

3

Something like this:

select db2.name, db1.*
from db1 join
     db2
     on db1.id = db2.id
where db1.date > '2018-01-01';

Depending on the structure of your tables this might be exactly equivalent. However, based on your question, I'm guessing that this is what you really want to accomplish.

answered Jan 9, 2018 at 4:12

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chan Over a year ago

Thank you very much, Gordon.

Asromi rOmi · Accepted Answer · 2018-01-09 04:43:35Z

2

Try This One

select  AA.*, BB.Name
from db1 AA
Left Join db2 BB On BB.id = AA.id
Where AA.date > '2018-1-1'

answered Jan 9, 2018 at 4:43

Asromi rOmi

1992 silver badges7 bronze badges

1 Comment

Chan Over a year ago

Thank you, Asromi.

Collectives™ on Stack Overflow

Combining two SQL query commands

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related