Re: suggestions for good graphical DB query builder
Date: Sat, 22 Sep 2007 07:17:35 GMT
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
>>>>> 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
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')
>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
>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