Difference between revisions of "Nejstarší rezervace"
From Wikivyuka
m |
|||
| Line 1: | Line 1: | ||
| − | SELECT TOP 1 REZERVACE.datum_rez, CTENAR.jmenoC, CTENAR.prijmeniC | + | SELECT TOP 1 REZERVACE.datum_rez, CTENAR.jmenoC, CTENAR.prijmeniC |
| − | FROM CTENAR INNER JOIN REZERVACE ON CTENAR.c_cten = REZERVACE.c_cten | + | FROM CTENAR INNER JOIN REZERVACE ON CTENAR.c_cten = REZERVACE.c_cten |
| − | ORDER BY REZERVACE.datum_rez; | + | ORDER BY REZERVACE.datum_rez; |
Revision as of 11:56, 5 December 2011
SELECT TOP 1 REZERVACE.datum_rez, CTENAR.jmenoC, CTENAR.prijmeniC FROM CTENAR INNER JOIN REZERVACE ON CTENAR.c_cten = REZERVACE.c_cten ORDER BY REZERVACE.datum_rez;
