combobox.
Is what I'm trying to do possible???
George
----- Original Message -
From:
Louise
Cofield
To: 'George Weaver' ; [EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:19
PM
Subject: RE: [SQL] Looks are
importa
Title: Message
Try the TRIM function or
the LTRIM function:
SELECT RPAD(no,30,' ') || TRIM(tableb.kind) FROM tablea
WHERE tablea.kind = tableb.kind
Louise
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of George WeaverSent: Wednesday, Nov
You will have to use a WHERE clause or a JOIN in query three, so you
will have to include some field, such as itemno, in the result sets of
both query1 and query2 on which you can join with where or join. Such
as:
Select query1.sumofqty as sum1, query2.sumofqty as sum2, query1.sumofqty
- query2.s
That was way too simple -- thank you!
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 10:38 AM
To: Louise Cofield
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Multiple table join
On Mon, Oct 06, 2003 at 10:26:59 -0600,
Louise Cofield
Greetings, SQL gurus!
I am attempting to select fields Location and Item_Num from
table A where A.Location = B.Location,
AND
select Item_Description from table C, where A.Item_Num = C.Item_Num.
Any help would be appreciated.
Louise
