🚀 go-pugleaf

On Mon, 19 Jan 1998 23:07:38 GMT, Tim Smith wrote:

>I am trying to generate a simple report from our accounting programme.
>However the tables do not have a key field, and are read only. (they
>do have key fields, but the child table field is all zeros) I am told
>the tables are linked using tags. I can link the tables in access
>using the following SQL
>
>SELECT DISTINCTROW *
>FROM POP_ITEM INNER JOIN PURCHASE_ORDER ON POP_ITEM.ORDER_NUMBER =
>PURCHASE_ORDER.ORDER_NUMBER;
>
>I am not having much luck using this code in the vdb (praise be to
>Borland) query designer. I have read the manual - honest.

The SQL-92 specification does not include a DISTINCTROW keyword. This must
be some implementation-specific keyword used in Microsoft Access. The rest
of your SQL statement is SQL-92 compliant enough that local SQL should
accept it. Try using the SQL-92 DISTINCT keyword rather than that
nonstandard DISTINCTROW.

  SELECT DISTINCT *
  FROM POP_ITEM PI
    INNER JOIN PURCHASE_ORDER PO
      ON (PI.ORDER_NUMBER = PO.ORDER_NUMBER);

**************************************************************************
Steve Koterski
Borland International, Inc.
http://www.borland.com/delphi
(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)