Re: suggestions for good graphical DB query builder

From: David Segall <david_at_address.invalid>
Date: Sat, 22 Sep 2007 07:17:35 GMT
Message-ID: <>

DA Morgan <> wrote:

>>>> 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
>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

Original text of this message