-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Âûâåñòè â 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó