Fórum SQL com Join para retornar campos correspondentes... #254473

Select C.CodCardapio, P1.Descricao as PRATO1, P2.Descricao as PRATO2, P3.Descricao as PRATO3, P4.Descricao as PRATO4 from Cardapio as C
  INNER JOIN Pratos as P1 ON (P1.Codigo = C.Prato1)
  INNER JOIN Pratos as P2 ON (P2.Codigo = C.Prato2)
  INNER JOIN Pratos as P3 ON (P3.Codigo = C.Prato3)
  INNER JOIN Pratos as P4 ON (P4.Codigo = C.Prato4)

select
  C.CODCARDAPIO,
  P1.DESCRICAO as PRATO1,
  P2.DESCRICAO as PRATO2,
  P3.DESCRICAO as PRATO3,
  P4.DESCRICAO as PRATO4
from CARDAPIO C
left join PRATOS P1 on (C.CODCARDAPIO = P1.CODIGO)
left join PRATOS P2 on (C.CODCARDAPIO = P2.CODIGO)
left join PRATOS P3 on (C.CODCARDAPIO = P3.CODIGO)
left join PRATOS P4 on (C.CODCARDAPIO = P4.CODIGO)

create table PRATOS (
  CODIGO INTEGER not null,
  DESCRICAO VARCHAR(40),
  constraint PK_PRATOS primary key (CODIGO)
);

create table CARDAPIO (
  CODCARDAPIO integer not null,
  PRATO1 integer,
  PRATO2 integer,
  PRATO3 integer,
  PRATO4 integer,
  constraint PK_CARDAPIO primary key (CODCARDAPIO),
  constraint FK_CARDAPIO_A foreign key (PRATO1) references PRATOS (CODIGO),
  constraint FK_CARDAPIO_B foreign key (PRATO2) references PRATOS (CODIGO),
  constraint FK_CARDAPIO_C foreign key (PRATO3) references PRATOS (CODIGO),
  constraint FK_CARDAPIO_D foreign key (PRATO4) references PRATOS (CODIGO)
);

select
  C.CODCARDAPIO,
  P1.DESCRICAO as DESCPRATO1,
  P2.DESCRICAO as DESCPRATO2,
  P3.DESCRICAO as DESCPRATO3,
  P4.DESCRICAO as DESCPRATO4
from CARDAPIO C
left join PRATOS P1 on (C.PRATO1 = P1.CODIGO)
left join PRATOS P2 on (C.PRATO2 = P2.CODIGO)
left join PRATOS P3 on (C.PRATO3 = P3.CODIGO)
left join PRATOS P4 on (C.PRATO4 = P4.CODIGO)