Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Connecting to SQL data w/FM

Brent C
in External Data Sources

Featured Replies

  • Newbies

Hopefully this is easy. I am new to using the ODBC connections. I want to use Filemaker to pull data from an existing SQL database. Simple enought to do when there are 2 tables involved. I am stuck trying to figure out how to tell filemaker I want to join more than one table? If anyone could point me in the right direction I would be very greatful.

If you want to join records from multiple tables, the key is the WHERE statement in SQL...

so it you have a one-to-many relationship with a primary key and foreign key fields..

SELECT (bunch of fields) FROM (bunch of tables) WHERE (some condition limiting the records returned)

example:

SELECT "DEPARTMENT"."acct_area", "DEPARTMENT"."dept_name", "ACCOUNT"."acct_title"

FROM "DEPARTMENT", "ACCOUNT"

WHERE "DEPARTMENT"."acct_area" = "ACCOUNT"."acct_area"

This will pull all the account records along with the related department information. The built-in query builder helps you get the syntax right...

Create an account or sign in to comment

https://fmforums.com/topic/38857-connecting-to-sql-data-wfm/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.