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

[Jonathan Schwartz]

Thanks Leo,

It's reassuring that I'm on the right track.

I've seen mention that the syntax on multiple join statements is more stringent than on single statements,  so maybe I need to use full syntax such as LEFT OUTER JOIN in stead of just JOIN.

Or...maybe my problem is that a FileMaker related query isn't a LEFT JOIN.  Is an INNER JOIN?

Jonathan


On Dec 9, 2013, at 12:13 PM, Leo R. Lundgren wrote:

> 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
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

Jonathan Schwartz
jschwartz at exit445.com