Results 1 to 6 of 6

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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. Íÿêàêâà èäåÿ êàê äà ãî íàïðàâÿ?

  2. #2
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    Ìììì... ïúðâî âçèìàø âñè÷êî îò À è êàêâîòî òè òðÿáâà îò Á, ïîñëå êúì ðåçóëòàòà äîáàâÿø êàêâîòî òè òðÿáâà îò Â?
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  3. #3
    Registered User
    Join Date: Nov:2011
    Location: Sofia
    Posts: 165
    Íå íå ñòàâà òàêà, êàòî ñëîæèø 3òà òàáëèçà â query-òî è ïðîãðàìà âåäíàãà âðúùà ãðåøêà ÷å íåìîæåø äà èìàø ïîâå÷å îò äâå òàáëèöè ïðè outer join. Âúçìîæíî å îáà÷å òîâà äà å îãðàíè÷åíèå íà MS Query, íå ñúì ïðîáâàë ñ Access äà âèäÿ äàëè ñòàâà.

  4. #4
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    select * from (
    select * from a left join b
    ) left join c
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  5. #5
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    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
    Áàçàòà íà EVE Online, ðàçïúíàòà íà MS SQL Server 2008.
    Íå ÷å ðåçóëòàòà îò òîâà query å íåùî ñìèñëåíî, ïðîñòî äà âèäèø êàê ñòàâà.
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  6. #6
    Registered User
    Join Date: Jun:2008
    Location: Äîáúð äåí
    Posts: 317
    Äà, â Îðàêúë ìîæå è áåç ñêîáè, íî çà MS ñà íóæíè.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè