Using FileMaker's SQL UNION to combine data

At Pause On Error I was scheduled to lead a discussion about using the SQL API in FileMaker Pro but nixed it to make room for other presenters. Instead I talked about FileMaker MVC with Ernest and data modeling with David Graham of BitTailor. Because of the popularity of the topic, however, I thought I'd address a few of the questions I received in hallways and at the bar here.

Proof presenting with MIT at CASE

Mike Lee will be speaking at the CASE District I conference in Boston with Donna Savelli Orleman from the MIT Alumni Association. The title of the session is: Getting Everyone on the Same Page: Integrating Databases. Mike and Donna will be discussing the work that Proof and the MITAA have done integrating Oracle and FIleMaker Pro. From the CASE program guide:

A Word About Licensing

To: Our Prospective School Software Customers

Recently, we've been getting some great questions from you about our licensing terms and how they compare to other FileMaker school database products. While I can't speak to how other companies handle this, I thought I'd take the opportunity to talk about how Proof's licenses work. I've put together a more complete FAQ on this topic but here are some highlights.