SQL and query designer (5.5)

Article View: borland.public.vdbase.data.sql

Article #1395

Back to borland.public.vdbase.data.sql Previous Next

#1395

From: Tim Smith
Date: Mon, 19 Jan 1998 00:00

24 lines
1137 bytes

Hi all

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.

Thanks for any help

Tim
--
Tim Smith
If you can read this replace deleteme with Tim to reply

deleteme@dhscient.demon.co.uk

Technical Details

Message-ID: <34c3dafe.9355111@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,bf04adadd27a4fa9,start
X-Google-Attributes: gidff5a1,public
From: Tim Smith
Subject: SQL and query designer (5.5)
Date: 1998/01/19
Message-ID: <34c3dafe.9355111@forums.borland.com>
X-Deja-AN: 317487692
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: None
Newsgroups: borland.public.vdbase.data.sql