Database connection

Question

On table A I got these two fields:

user_level, username

On table B I got these two fields:

username, notes

I would like to use a mysql query to fetch the notes from all usernames where the level_id = 4.
How would the database connection look like to achieve this?

Thanks in advance

Nothing about connection here. You need sql query.

Emmerman
– Emmerman

2011-04-26 07:49:30 +00:00
Commented Apr 26, 2011 at 7:49 — Emmerman
– Emmerman, Commented Apr 26, 2011 at 7:49

Emmerman · Accepted Answer · 2011-04-26 07:50:24Z

1

SELECT * FROM `A` JOIN `B` USING(`username`) WHERE `user_level` = 4;

answered Apr 26, 2011 at 7:50

Emmerman

2,34315 silver badges9 bronze badges

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

Comments

jimy · Accepted Answer · 2011-04-26 07:51:50Z

1

SELECT notes FROM B b INNER JOIN A a ON (b.username = a.username) WHERE a. user_level = 4

answered Apr 26, 2011 at 7:51

jimy

4,9183 gold badges37 silver badges52 bronze badges

Comments

Mikecito · Accepted Answer · 2011-04-26 07:50:16Z

0

Select username, notes from B inner join A on a.username=b.username where user_level=4

answered Apr 26, 2011 at 7:50

Mikecito

2,06311 silver badges17 bronze badges

Collectives™ on Stack Overflow

Database connection

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related