[FX.php List] About migrating to MySQL: Pulling data from multiple related tables

[Leo R. Lundgren]

You're on the right track. You simply join in multiple tables, can do that within the same query.

Here's a nice little visualization of various join types, thought it might be helpful in general:  http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html


9 dec 2013 kl. 21.09 skrev Jonathan Schwartz:

> Hi Folks,
> 
> Haven't posted for awhile....
> 
> I'm doing my first migration to MySQL and need some advice on how to accomplish the same functionality on MySQl as on FileMaker.
> 
> Performing a simple query in a single table proved easy.
> 
> The problem is how to retrieve data from multiple related tables.  I added a "LEFT JOIN" statement to the MySQL query and successfully pulled data from one related table, but failed to get results from multiple related tables.  It could have been syntax errors on the subsequent JOIN statements.
> 
> Am I approaching this correctly?
> 
> In FileMaker, we often have many related tables and can pull from any (as long as they are on the layout).  I'm not getting the same vibe from MySQL as I explore the options.
> 
> I used brute force to get past the issue: I issued multiple queries, one to each table...but I'm pretty sure that's not the way to go. ;-)
> 
> Any guidance would be appreciated.
> 
> Thanks
> 
> Jonathan