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'
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 9:48 AM
Subject: Creating the correct SQL statement
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 a
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
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' to
convert Pesetas to Pound Stirling. ( divide
