multiple fields from single table update/select query

[hanyz.dx]

Hi all,


I'm trying to solve this issue:

I've got 2 tables, 1st table (s_mo) has in record 3 fields with IDs of cabinets (s_mo.ID_SK1;2;3), 2nd table (s_cabinet) contains list of cabinets with related IDs (s_cabinet.id).

I need to create query (other then UNION) which will look in s_cabinets and give back cabinet names (s_cabinet.name) to fields SK1, SK2, SK3 which will relate to ID_SK1;2;3 in s_mo

thanks for advice

[hanyz.dx]

build n-to-1 relation between

s_mo.ID_SK1->s_cabinet.ID
s_mo.ID_SK2->s_cabinet.ID
s_mo.ID_SK3->s_cabinet.ID

statement below must be inserted in fields name in query declaration:

SK1: (SELECT [NAME] FROM [s_cabinet] WHERE [s_mo].[ID_SK1]=[s_cabinet].[ID])

and repeated for SK2 and SK3 in same query