AnsweredAssumed Answered

How To Present Data From SQL Union

Question asked by LeoCA on Jun 17, 2009
Latest reply on Jun 18, 2009 by comment_1

Title

How To Present Data From SQL Union

Post

We have similar data in various tables and need to compile a comprehensive list. The following SQL can generalize what we try to achieve: 

 

Select field1, field2, field3 From Table1

UNION

Select field1, field2, field3 From Table2

UNION

Select field1, field2, field3 From Table3

Order BY field1

 

How can we get results by using FileMaker Pro 8.5?  Your directions are appreciated.

 

LeoCA

Outcomes