CardExchange Internal View

Owned by Craig Bechelli (Deactivated)
May 29, 2019
1 min read

Within the database setup in CardExchange Producer, it is possible to define an internal view to load information from multiple tables within the same database.
Below is an example of such an internal view:

SELECT Names.StudentKey, Names.FirstName, Names.Surname, Studentno.[Student Card No]

From [Names] INNER JOIN Studentno ON Names.StudentKey = Studentno.StudentKey


Also below is a more complex join on three different tables:

SELECT cd.CardholderID,

cd.UsergroupID,

cd.CostaccountID,

ug.Usergroupname,

ca.Costaccountname,

cd.Issuenr,

cd.CardNr,

cd.Startdate,

cd.Enddate,

cd.PinCode,

cd.Cardbalance,

ch.Perscode,

ch.Name,

ch.Surname,

ch.Address,

ch.Phone1,

ch.Extra3

FROM (((card cd

INNER JOIN cardholder ch ON cd.CardholderID = ch.CardholderID)

INNER JOIN usergroup ug ON cd.UsergroupID = ug.UsergroupID)

INNER JOIN costaccount ca ON cd.CostaccountID = ca.CostaccountID)