Âûâåñòè â DBGrid âìåñòî ID íàçâàíèÿ
|
|
Âîñêðåñåíüå, 08 Èþíÿ 2014 ã. 15:08
+ â öèòàòíèê
Çäðàâñòâóéòå.
Åñòü 3 òàáëèöû:
Òåìà
Ïîëå 1- ID_Tem ID
Ïîëå 2- Íàçâàíèå
Ïîëüçîâàòåëè
Ïîëå 1- ID_Uch
Ïîëå 2-Èìÿ
Æóðíàë
Ïîëå 1-ID_Uch
Ïîëå 2-ID_Tem
Ïîëå 3-Ðåçóëüòàò
ß õî÷ó Æóðíàë âûâåñòè â DBGrid, íî ÷òîáû âìåñòî ID îòîáðàæàëèñü íàçâàíèÿ.
Ïðîáóþ ÷åðåç òàêîé SQL-çàïðîñ:
ADOQuery1->SQL->Add("SELECT * FROM Æóðíàë INNER JOIN Êîðèñòóâà÷³ ON ID_Uch = ID_Uch");
Ïèøåò "Âûðàæåíèå îáúåäèíåíèå íå ïîääåðæèâàåòñÿ"
Ïîäñêàæèòå ïîæàëóéñòà.
http://www.sql.ru/forum/1099193/vyvesti-v-dbgrid-vmesto-id-nazvaniya
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-