problem with query

Question

what i am trying:

SELECT 
`update_photo`, 
(SELECT substring_index (`username`, ' ', 1)), 
`id_user`
FROM users 

JOIN worker_has_profession
ON worker_has_profession.worker_single_user_users_id_user  = users.id_user

ORDER BY `registration` 
DESC LIMIT 10

The output will be:

path photo | John | 31

but i need something like this (profession is in another table)

path photo | John | 31 | designer

Tables

   <table worker_has_profession>
    worker_single_user_users_id_user //same id of id_user
    profession_id_profession 

      worker_single_user_users_id_user            profession_id_profession 
                    31                                      10


   <table profession>
    id_profession 
    profession

     id_profession               profession 
           10                      designer

Any idea?

So why don't you select necessary field then?

zerkms
– zerkms

2011-06-23 02:12:30 +00:00
Commented Jun 23, 2011 at 2:12 — zerkms
– zerkms, Commented Jun 23, 2011 at 2:12
how? the field that i need is in another table

daniel__
– daniel__

2011-06-23 02:15:14 +00:00
Commented Jun 23, 2011 at 2:15 — daniel__
– daniel__, Commented Jun 23, 2011 at 2:15
you have already added one join, so add another one.

zerkms
– zerkms

2011-06-23 02:30:26 +00:00
Commented Jun 23, 2011 at 2:30 — zerkms
– zerkms, Commented Jun 23, 2011 at 2:30

JasonG · Accepted Answer · 2011-06-23 02:33:14Z

2

Added the join below and profession to select list.

SELECT 
update_photo, 
(SELECT substring_index (`username`, ' ', 1)), 
U.id_user,
P.profession
FROM users U

JOIN worker_has_profession WP
ON WP.worker_single_user_users_id_user  = U.id_user

JOIN profession P
ON P.id_profession =  WP.profession_id_profession
ORDER BY registration
DESC LIMIT 10

edited Jun 23, 2011 at 2:33

answered Jun 23, 2011 at 2:25

JasonG

9226 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

problem with query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related