On 21-Jun-01 Craig Atkins wrote:
> Hello,
> _
> I am a little stumped on how to create the select statement that I need.
> _
> I have a_table of items, with a column called price, which contains a
> price in Spainish Pesetas.
> I have another table, with 1 record, that contains an 'exchange rate'
Is there a way to relate the items table to the exchange table? i.e. does
your item have an excahngeID? (probably not) Does you item have a FK
relationship into a Vendor/Mfgr who has a FK into exchange? (this would make
more sense.)
If so, we can probably figure it out, If there is no way to rel
ot;'Craig Atkins'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 3:54 PM
Subject: RE: Creating the correct SQL statement
Hi
If I am right you can not do this in one move..
You can use temp tables to help thow
Hope this helps a bit
Simon
Hi
If I am right you can not do this in one move..
You can use temp tables to help thow
Hope this helps a bit
Simon
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2001 15:48
To: '[EMAIL PROTECTED]'
Subject: Creating the correct SQL statement
Hel