linking database column entries if a is this then b is that

[Renae96]

I need help in linking several columns. If the first column is on thing then
that determines the contents of 3 other columns. How do you link them?

 

[Stefan Hoffmann]

hi,

I need help in linking several columns. If the first column is on thing then
that determines the contents of 3 other columns. How do you link them?

This makes no sense.

The only thing I can imagine:

SELECT
firstColumn,
IIf(firstColumn=oneThing, columnA, columnD),
IIf(firstColumn=oneThing, columnB, columnE),
IIf(firstColumn=oneThing, columnC, columnF)
FROM
yourTable

mfG
--> stefan <--