Returning rows even when query value is not found











up vote
1
down vote

favorite












I have a query like below in SQL. I would like to return Item with quantity: 0 even when it does not return any data (i.e. 590209, 590212 does not exist in my records). I have probably 10000 records I need to return. Any idea how to do it? 



SELECT [Item] ,[Qty] 

  FROM Table

  where Item in (590209,590210,590211,590212,590213)


Results should be like



Item     Qty

590209   0

590210   3

590211   1

590212   0

590213   1





sql







share|improve this question




















  • 2




    which db you are using??
    – scaisEdge
    Nov 9 at 8:17

















up vote
1
down vote

favorite












I have a query like below in SQL. I would like to return Item with quantity: 0 even when it does not return any data (i.e. 590209, 590212 does not exist in my records). I have probably 10000 records I need to return. Any idea how to do it? 



SELECT [Item] ,[Qty] 

  FROM Table

  where Item in (590209,590210,590211,590212,590213)


Results should be like



Item     Qty

590209   0

590210   3

590211   1

590212   0

590213   1





sql







share|improve this question




















  • 2




    which db you are using??
    – scaisEdge
    Nov 9 at 8:17















up vote
1
down vote

favorite









up vote
1
down vote

favorite











I have a query like below in SQL. I would like to return Item with quantity: 0 even when it does not return any data (i.e. 590209, 590212 does not exist in my records). I have probably 10000 records I need to return. Any idea how to do it? 



SELECT [Item] ,[Qty] 

  FROM Table

  where Item in (590209,590210,590211,590212,590213)


Results should be like



Item     Qty

590209   0

590210   3

590211   1

590212   0

590213   1





sql







share|improve this question















I have a query like below in SQL. I would like to return Item with quantity: 0 even when it does not return any data (i.e. 590209, 590212 does not exist in my records). I have probably 10000 records I need to return. Any idea how to do it? 



SELECT [Item] ,[Qty] 

  FROM Table

  where Item in (590209,590210,590211,590212,590213)


Results should be like



Item     Qty

590209   0

590210   3

590211   1

590212   0

590213   1





sql




sql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 9 at 10:14









Mukyuu

3191216




3191216










asked Nov 9 at 8:15









user10627737

82




82








  • 2




    which db you are using??
    – scaisEdge
    Nov 9 at 8:17
















  • 2




    which db you are using??
    – scaisEdge
    Nov 9 at 8:17










2




2




which db you are using??
– scaisEdge
Nov 9 at 8:17






which db you are using??
– scaisEdge
Nov 9 at 8:17














2 Answers
2






active

oldest

votes

















up vote
0
down vote



accepted










try like below



select t.Item,t1.Qty from 

(

select 590209  as Item

union all

select 590210 

union all

select 590211 

union all

select 590212

 union all

select 590213

) t left join your_table t1

  on t.Item=t1.Item





share|improve this answer




























    up vote
    0
    down vote













    You can try like below to return "Item" with quantity 0 



    SELECT [Item] ,[Qty] 
    
FROM Table 
    
where Qty = 0





    share|improve this answer





















      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














       

      draft saved


      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222004%2freturning-rows-even-when-query-value-is-not-found%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes








      up vote
      0
      down vote



      accepted










      try like below



      select t.Item,t1.Qty from 
      
(
      
select 590209  as Item
      
union all
      
select 590210 
      
union all
      
select 590211 
      
union all
      
select 590212
      
 union all
      
select 590213
      
) t left join your_table t1
      
  on t.Item=t1.Item





      share|improve this answer

























        up vote
        0
        down vote



        accepted










        try like below



        select t.Item,t1.Qty from 
        
(
        
select 590209  as Item
        
union all
        
select 590210 
        
union all
        
select 590211 
        
union all
        
select 590212
        
 union all
        
select 590213
        
) t left join your_table t1
        
  on t.Item=t1.Item





        share|improve this answer























          up vote
          0
          down vote



          accepted







          up vote
          0
          down vote



          accepted






          try like below



          select t.Item,t1.Qty from 
          
(
          
select 590209  as Item
          
union all
          
select 590210 
          
union all
          
select 590211 
          
union all
          
select 590212
          
 union all
          
select 590213
          
) t left join your_table t1
          
  on t.Item=t1.Item





          share|improve this answer












          try like below



          select t.Item,t1.Qty from 
          
(
          
select 590209  as Item
          
union all
          
select 590210 
          
union all
          
select 590211 
          
union all
          
select 590212
          
 union all
          
select 590213
          
) t left join your_table t1
          
  on t.Item=t1.Item






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 9 at 8:19









          Zaynul Abadin Tuhin

          10.6k2731




          10.6k2731
























              up vote
              0
              down vote













              You can try like below to return "Item" with quantity 0 



              SELECT [Item] ,[Qty] 
              
FROM Table 
              
where Qty = 0





              share|improve this answer

























                up vote
                0
                down vote













                You can try like below to return "Item" with quantity 0 



                SELECT [Item] ,[Qty] 
                
FROM Table 
                
where Qty = 0





                share|improve this answer























                  up vote
                  0
                  down vote










                  up vote
                  0
                  down vote









                  You can try like below to return "Item" with quantity 0 



                  SELECT [Item] ,[Qty] 
                  
FROM Table 
                  
where Qty = 0





                  share|improve this answer












                  You can try like below to return "Item" with quantity 0 



                  SELECT [Item] ,[Qty] 
                  
FROM Table 
                  
where Qty = 0






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 9 at 8:16









                  Sanal Sunny

                  5787




                  5787






























                       

                      draft saved


                      draft discarded



















































                       


                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222004%2freturning-rows-even-when-query-value-is-not-found%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      -

                      Popular posts from this blog

                      Schultheiß

                      Image
                      Der Titel dieses Artikels ist mehrdeutig. Weitere Bedeutungen sind unter Schultheiß (Begriffsklärung) aufgeführt. Ein Schultheiß. Holzschnitt von Peter Flötner (16. Jahrhundert) Der Schultheiß oder Schuldheiß (von althochdeutsch  sculdheizo ‚Leistung Befehlender‘, vgl. mittelniederdeutsch  schult(h)ēte , latinisiert (mittellat.) sculte(t)us , schwäbisch heute noch Schultes für „Bürgermeister“) bezeichnet einen in vielen westgermanischen Rechtsordnungen vorgesehenen Beamten, der Schuld heischt : Er hatte im Auftrag seines Herren (Landesherrn, Stadtherrn, Grundherrn) die Mitglieder einer Gemeinde zur Leistung ihrer Schuldigkeit anzuhalten, also Abgaben einzuziehen oder für das Beachten anderer Verpflichtungen Sorge zu tragen. Sprachliche Varianten des Schultheißen sind Schulte , Schultes oder Schulze . Früher wurde zwischen dem Stadtschulzen und dem Dorfschulzen unterschieden. In der städtischen Gerichts- und Gemeindeverfassung war er ein vom städtischen Rat oder vom L
                      Read more

                      Liste der Kulturdenkmale in Wilsdruff

                      Image
                      Wappen von Wilsdruff Die Liste der Kulturdenkmale in Wilsdruff enthält die Kulturdenkmale in Wilsdruff. Die Anmerkungen sind zu beachten. Diese Liste ist eine Teilliste der Liste der Kulturdenkmale im Landkreis Sächsische Schweiz-Osterzgebirge. Diese Liste ist eine Teilliste der Liste der Kulturdenkmale in Sachsen. Inhaltsverzeichnis 1 Legende 2 Wilsdruff 3 Birkenhain 4 Blankenstein 5 Braunsdorf 6 Grumbach 7 Grund 8 Helbigsdorf 9 Herzogswalde 10 Kaufbach 11 Kesselsdorf 12 Kleinopitz 13 Limbach 14 Mohorn 15 Oberhermsdorf 16 Anmerkungen 17 Ausführliche Denkmaltexte 18 Quellen 19 Weblinks Legende | Bild: zeigt ein Bild des Kulturdenkmals und gegebenenfalls einen Link zu weiteren Fotos des Kulturdenkmals Bezeichnung: Name, Bezeichnung oder die Art des Kulturdenkmals Lage: Straßenname und wenn vorhanden Hausnummer des Kulturdenkmals; Grundsortierung der Liste erfolgt nach dieser A
                      Read more

                      Android Play Services Check

                      Image
                      up vote 0 down vote favorite Im facing a problem currently im making my app to run on t.v its working fine on mobiles. but the issue is if i run my app on t.v emulator splash screen appears then the app crashes log shows this error. No acceptable module found. Local version is 0 and remote version is 0 i googled this error and came with a solution that my emulator should have latest google play services installed in it.. but in my t.v emulator there is no play store so i cant update my play services to latest version. so is there any way to make a check that if play services version is less then this so run the app instead of crashing, and if the play services version is latest also run the aap... here is my code where im getting the play services version.. int playServicesAvailable = GoogleApiAvailability.g
                      Read more