How to do multiple select and then concat data together in mysql

Question

Am trying to retrieve data from 3 tables at once but i am not sure how to do it in mysql (to be truthful i am really bad at database stuff so this confuse the hell out me).

1st logins table that has 3 columns id, email, password
2nd users table that has 4 columns id, name, surname, location_id
3rd locations has 3 columns location_id, country, city

what i want to do is write query using the users id to get the email from the logins table, then get name and surname from the users table. I then want to use the location_id i got from the users table to find out what city he or she is from.

i hope that makes sense to you and thanks for your time.

@Shadow thanks for the help – Newbie2016 Mar 07 '17 at 17:02 — Newbie2016, Mar 07 '17 at 17:02

score -1 · Accepted Answer · answered Mar 07 '17 at 16:25

-1

maybe this could be helpful

select a.email, B.name, B.surname, C.city
from logings A join users B on (A.id=B.id) join locations C on

answered Mar 07 '17 at 16:25

Judith Palacios

413
2
9

shadow pointed me to the correct post, thanks for the help by the way – Newbie2016 Mar 07 '17 at 17:05

How to do multiple select and then concat data together in mysql

1 Answers1