Home Join two or three tables in a select to get an result in Mysql Linux
Reply: 0

Join two or three tables in a select to get an result in Mysql Linux

Samuel Oliveira
1#
Samuel Oliveira Published in 2018-02-13 18:21:24Z

I have this three tables.

enter image description here

I need to do a select to get Full name and mobile phone numbers for each person and another List of people living on Lucas st., their home addresses and home phone numbers, like a

enter image description here

I believe that need to use join to accomplish this but I cannot figure out which full command i need to use. Does anyone can help me with that?

Thanks.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.293387 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO