DreamGenius
Annoying Questionner
- Local time
- Today, 23:49
- Joined
- Jul 29, 2004
- Messages
- 116
Is it possible to do the above?
I have an invoice tracking database where blocks of 500 invoice numbers are allocated to a biller. When invoices are received back with these numbers, the client, value and currency are entered into that record in the database.
I want to validate the Currency field using a query against a table that contains all of the offices that we operate in, with their currency. This table is rebuilt regularly to pick up new offices from our main Oracle database.
In short, = (in (select distinct [Currency].[Currency] from [Currency]) )doesn't work!
I have an invoice tracking database where blocks of 500 invoice numbers are allocated to a biller. When invoices are received back with these numbers, the client, value and currency are entered into that record in the database.
I want to validate the Currency field using a query against a table that contains all of the offices that we operate in, with their currency. This table is rebuilt regularly to pick up new offices from our main Oracle database.
In short, = (in (select distinct [Currency].[Currency] from [Currency]) )doesn't work!
