| |

VerySource

 Forgot password?
 Register
Search
View: 7|Reply: 2

Seeking simple SQL statements

[Copy link]

1

Threads

3

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-1-23 16:40:01
| Show all posts |Read mode
Find the merchant id according to the conditions, and then find the regional id based on the found merchant id
Finally, I need to find the business id and area id, and I want to complete it in one sentence, help

Business table shangjia, area table diqu, everyone help
Reply

Use magic Report

1

Threads

3

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-2-11 12:00:02
| Show all posts
up
Reply

Use magic Report

0

Threads

5

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-6-1 12:30:01
| Show all posts
select b. region name, a. business name from business as a left join region as b on a. region ID = b.id where a. condition field = condition
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list