Hi Elgin,

You didn't explain why do you need FULL JOIN. Maybe LEFT JOIN will do?

>The six tables I am trying to join contain different types of test analyses for hundreds of clients. Each table has a CUSTID, UPSINO, and PULDAT, field. I want to use these three fields as the join conditions. I will always specify a single CUSTID, "SC100234" as a filter criteria. For the UPSINO and PULDAT, I may or may not specify some additional filter criteria.
>
>For example, in one instance I may want to pull all test results for all dates for a single client, "SC100234". In another instance, and probably most common, I will specify a single CUSTID and a single PULDAT as criteria.
>
>The SELECT statement I posted in my earlier entry contained only a few of the fields from each table. I will be adding more fields for each table and a couple more tables.
>
>My ultimate goal is to build a "Field Chooser" form in order to build this SELECT statement dynamically. I thought I would work on this SELECT statement first to learn what I am up against in doing this. I know someone has probably already done this in some form or fashion, but I want to do my own version so I can LEARN.
>
>As always, thank you for your assistance.
>
>
>