I have three really small tables, which gave me a lot of headache.
They reside in a MS Access database and a I am accessing them through
ADO.NET(VB).
Can't figure out how to make a "Select" query on them.
These are the tables:
1St - "Transactions"
TransactionID - primary key, autogen
TransactionNum - alphanumeric
TransactionDate - short date
Amount - number
CurrencyID - number - foreign key to Currencies
ForeginCurrencyAmount - number
CurrencyID - number - foreign key to Currencies
SenderName - text
SenderCountryID - number - foreign key to Countries
ReceiverName - text
ReceiverCountryID  - number - foreign key to Countries
2nd table - "Currencies":
CurrencyID - primary key, autogen
CurrencyName - text
3rd table - "Countries":
CountryID - primary key, autogen
CountryName - Text

I need a query which shows the following:
TransactionDate
Amount
CurrencyName(for Amount)
ForeginCurrencyAmount
CurrencyName (for Foregin Amount)
CountryName (for Sender)
CountryName (for Receiver)

Any help will be greatly appreciated

Please post proper DDL, so that we can create your objects. Some sample data
and expected results might also be of great help.
http://www.aspfaq.com/etiquette.asp?id=5006


ML

---
http://milambda.blogspot.com/

COnverting CSV to XLS file
VB.NET Thread Garbage Collection
Property and type
easy one
Problems with Quotes in SQL queries in VB.Net
Windows Thumbnail Control
Regular Expressions Problem
Failure Sending Mail exception with VS 2005
Microsoft VBScript compilation error '800a0400'
Where did this come from: Microsoft\CStoVBConverter\Samples\Smart Client\