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

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

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

 

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

 -Ñòàòèñòèêà

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


Çàïðîñ â Access èç ïðèëîæåíèÿ

Ñðåäà, 08 Íîÿáðÿ 2017 ã. 20:58 + â öèòàòíèê
Çäðàâñòâóéòå!

Åñòü ìàëåíüêàÿ áàçà äàííûõ Access è ðàçðàáàòûâàåòñÿ ïðèëîæåíèå íà VB.Net â Visual Studio.

+ Åñëè çàïóñòèòü òàêîé çàïðîñ â Access, òî ðåçóëüòàò êàê â ñêðèíøîòå
SELECT
	Ò1.Áðåíä,
	Ò1.Ãîðîä,
	Ò1.ßíâàðü,
	Ò1.Ôåâðàëü,
	Ò1.Ìàðò,
	Ò1.Àïðåëü,
	Ò1.Ìàé,
	Ò1.Èþíü,
	Ò1.Èþëü,
	Ò1.Àâãóñò,
	Ò1.Ñåíòÿáðü,
	Ò1.Îêòÿáðü,
	Ò1.Íîÿáðü,
	Ò1.Äåêàáðü
FROM
	Ïëàí Ò1

Íî åñëè çàïóñòèòü òàêîé çàïðîñ èç ïðèëîæåíèÿ, òî â ïîëÿõ "Áðåíä" è "Ãîðîä" ïðèñóòñòâóþò êîäû, íî íå ïîäñòàíîâêè.

Íàïèñàë äðóãèå âàðèàíòû çàïðîñîâ, ãäå äîáàâëÿþ êîëîíêè "Áðåíä" è "Ãîðîä" êàê íàèìåíîâàíèÿ.
+ Ïåðâûé âàðèàíò çàïðîñà
SELECT
	ÒÒÒ1.Áðåíä,
	ÒÒÒ1.Ãîðîä,
	ÒÒÒ1.ßíâàðü,
	ÒÒÒ1.Ôåâðàëü,
	ÒÒÒ1.Ìàðò,
	ÒÒÒ1.Àïðåëü,
	ÒÒÒ1.Ìàé,
	ÒÒÒ1.Èþíü,
	ÒÒÒ1.Èþëü,
	ÒÒÒ1.Àâãóñò,
	ÒÒÒ1.Ñåíòÿáðü,
	ÒÒÒ1.Îêòÿáðü,
	ÒÒÒ1.Íîÿáðü,
	ÒÒÒ1.Äåêàáðü,
	ÒÒÒ1.[Íàèìåíîâàíèå áðåíäà],
	ÒÒÒ2.Íàèìåíîâàíèå AS [Íàèìåíîâàíèå ãîðîäà]
FROM
	(SELECT
		ÒÒ1.Áðåíä,
		ÒÒ1.Ãîðîä,
		ÒÒ1.ßíâàðü,
		ÒÒ1.Ôåâðàëü,
		ÒÒ1.Ìàðò,
		ÒÒ1.Àïðåëü,
		ÒÒ1.Ìàé,
		ÒÒ1.Èþíü,
		ÒÒ1.Èþëü,
		ÒÒ1.Àâãóñò,
		ÒÒ1.Ñåíòÿáðü,
		ÒÒ1.Îêòÿáðü,
		ÒÒ1.Íîÿáðü,
		ÒÒ1.Äåêàáðü,
		ÒÒ2.Íàèìåíîâàíèå AS [Íàèìåíîâàíèå áðåíäà]
	FROM	
		(SELECT
			Ò1.Áðåíä,
			Ò1.Ãîðîä,
			Ò1.ßíâàðü,
			Ò1.Ôåâðàëü,
			Ò1.Ìàðò,
			Ò1.Àïðåëü,
			Ò1.Ìàé,
			Ò1.Èþíü,
			Ò1.Èþëü,
			Ò1.Àâãóñò,
			Ò1.Ñåíòÿáðü,
			Ò1.Îêòÿáðü,
			Ò1.Íîÿáðü,
			Ò1.Äåêàáðü
		FROM
			Ïëàí Ò1) AS ÒÒ1
	LEFT JOIN
		Áðåíäû  ÒÒ2
	ON
		ÒÒ1.Áðåíä=ÒÒ2.Êîä) AS ÒÒÒ1
LEFT JOIN
	Ãîðîäà ÒÒÒ2
ON
	ÒÒÒ1.Ãîðîä=ÒÒÒ2.Êîä
+ Âòîðîé âàðèàíò çàïðîñà
SELECT
	Ò1.Áðåíä,
	Ò1.Ãîðîä,
	Ò1.ßíâàðü,
	Ò1.Ôåâðàëü,
	Ò1.Ìàðò,
	Ò1.Àïðåëü,
	Ò1.Ìàé,
	Ò1.Èþíü,
	Ò1.Èþëü,
	Ò1.Àâãóñò,
	Ò1.Ñåíòÿáðü,
	Ò1.Îêòÿáðü,
	Ò1.Íîÿáðü,
	Ò1.Äåêàáðü,
	(SELECT Íàèìåíîâàíèå FROM Áðåíäû WHERE Êîä = Ò1.Áðåíä) AS [Íàèìåíîâàíèå áðåíäà],
	(SELECT Íàèìåíîâàíèå FROM Ãîðîäà WHERE Êîä = Ò1.Ãîðîä) AS [Íàèìåíîâàíèå ãîðîäà]
FROM
	Ïëàí Ò1

Ñêàæèòå, êàê ïðàâèëüíî çàïóñêàòü çàïðîñ èç ïðèëîæåíèÿ, ÷òîáû ïðèñóòñòâîâàëè ïîäñòàíîâêè? Ìîæåò áûòü íå íàäî â çàïðîñå äîáàâëÿòü åùå äâà ïîëÿ? Ìîæåò áûòü â Visual Studio åñòü ñïåöèàëüíîå ôóíêöèîíàëüíîñòü äëÿ ó÷åòà äàííîãî ñëó÷àÿ, òèïà ñâîÿ ñèñòåìà ïîäñòàíîâîê?

http://www.sql.ru/forum/1276495/zapros-v-access-iz-prilozheniya


 

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

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

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

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