Results 1 to 6 of 6
Thread: SQL âúïðîñ
Hybrid View
-
16th November 2012 09:56 #1Registered User
Join Date: Nov:2011
Location: Sofia
Posts: 165
SQL âúïðîñ
Çäðàâåéòå, èìàì ñëåäíèÿ ïðîáëåì:
Òðÿáâà äà èçâëåêà äàííè îò òðè òàáëèöè è äà ãè âúðíà â åêñåë. Çà öåëòà ïîëçâàì MS Query, ïðîáëåìà å îáà÷å ÷å èñêàì âñè÷êè äàííè îò òàáëèöà À (left outer join), à îò òàáëèöà B è C ñàìî òåçè êîèòî ñè ïàñâàò ïî äàäåí êðèòåðèé (inner join)
Ïðîáëåìà å ÷å MS Query ìè âðúùà ÷å íåìîæå äà èìàì Left outer join êîãàòî èìàì ïîâå÷å îò äâå òàáëèöè.
Çà äà ìè å ïúëíà ñïðàâêàòà ìè òðÿáâà âñè÷êî îò À è ñàìî îïðåäåëåíè íåùà îò B C. Íÿêàêâà èäåÿ êàê äà ãî íàïðàâÿ?
-
16th November 2012 14:50 #2
Ìììì... ïúðâî âçèìàø âñè÷êî îò À è êàêâîòî òè òðÿáâà îò Á, ïîñëå êúì ðåçóëòàòà äîáàâÿø êàêâîòî òè òðÿáâà îò Â?
ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1
-
16th November 2012 15:00 #3Registered User
Join Date: Nov:2011
Location: Sofia
Posts: 165
Íå íå ñòàâà òàêà, êàòî ñëîæèø 3òà òàáëèçà â query-òî è ïðîãðàìà âåäíàãà âðúùà ãðåøêà ÷å íåìîæåø äà èìàø ïîâå÷å îò äâå òàáëèöè ïðè outer join. Âúçìîæíî å îáà÷å òîâà äà å îãðàíè÷åíèå íà MS Query, íå ñúì ïðîáâàë ñ Access äà âèäÿ äàëè ñòàâà.
-
17th November 2012 11:36 #4
select * from (
select * from a left join b
) left join cASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1
-
17th November 2012 12:42 #5Áàçàòà íà EVE Online, ðàçïúíàòà íà MS SQL Server 2008.Code:
select * from (select staOperations.operationID, staOperations.activityID from staOperations left join staStations on staStations.operationID = staOperations.operationID) a left join ramActivities on a.activityID = ramActivities.activityID
Íå ÷å ðåçóëòàòà îò òîâà query å íåùî ñìèñëåíî, ïðîñòî äà âèäèø êàê ñòàâà.ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1
-
19th November 2012 22:54 #6Registered User
Join Date: Jun:2008
Location: Äîáúð äåí
Posts: 317
Äà, â Îðàêúë ìîæå è áåç ñêîáè, íî çà MS ñà íóæíè.




Reply With Quote
Ïðîáëåìíà R9 280, àðòåôàêòè
7th May 2023, 21:28 in Âèäåîêàðòè