Re: suggestions for good graphical DB query builder

DA Morgan <damorgan_at_psoug.org> wrote:

>>>> carol_marra_at_msn.com wrote:
>>>>
>>>>> We're an Oracle shop, but we need connectivity w/ any ODBC compliant
>>>>> DB.
>>>>> Also need query result export options (esp Excel), pivot capability,
>>>>> printable results,
>>>>> Windows compliant.

>>> I can't think of a worse tool [than Microsoft Access].
>
>Referring to the fact that the following query would be impossible
>to write:
I resile completely. Please post the name of the graphical DB query builder that meets the OP's specification and that you [could] have used to write the query.
>
>WITH w AS (
> SELECT person_id
> FROM person
> WHERE per_fmw = 'Y')
>SELECT per_h_email
>FROM person p, w
>WHERE p.person_id = w.person_id
>AND p.per_ok2_email = 'A'
>AND p.per_h_email IS NOT NULL
>UNION
>SELECT po_w_email
>FROM poie o, w
>WHERE o.person_id = w.person_id
>AND o.po_status = 'A'
>AND o.po_w_email IS NOT NULL;
>
>I would write dozens of other basic statements impossible to
>duplicate in MS Excess.
Received on Sat Sep 22 2007 - 09:17:35 CEST