A database which stores currency conversion values. These values will be added to text boxes according to the input date in a vb.net program.
Given the three tables
Dim sql As String = "SELECT TOP 1 GEUR,GUSD FROM GBPtb WHERE Date= ?"
With the limited information you provided, I'm guessing you might want something like the following
SELECT 1.0 as GBP, GUSD as USD, GEUR as EUR FROM GBP WHERE Date = ? UNION ALL SELECT UGBP as GBP, 1.0 as USD, UEUR as EUR FROM USD WHERE Date = ? UNION ALL SELECT EGBP as GBP, EUSD as USD, 1.0 as EUR FROM EUR WHERE Date = ?