How to form this SQLite query?

Question

I have two table, one is

ItemData(ItemID, ItemName)

and other one has few columns.

I can retrieve IDs from second table but I want ItemNames corresponding to those iIDs. I used following code but it is returning only one item name:

SELECT ItemName
  FROM ItemData
 WHERE ItemID = ( SELECT ItemID
                    FROM StoreItem
                   WHERE StoreId = 3
                     AND Value = 1)

juergen d · Accepted Answer · 2012-08-07 11:11:43Z

1

SELECT ItemName from ItemData
WHERE ItemID in ( SELECT ItemID from StoreItem WHERE StoreId = 3 AND Value = 1)

answered Aug 7, 2012 at 11:11

juergen d

205k40 gold badges304 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

omggs · Accepted Answer · 2012-08-07 11:19:59Z

1

If your inner query returns more than 1 ItemID then use the IN clause -

SELECT ItemName from ItemData WHERE ItemID IN ( SELECT ItemID from StoreItem WHERE StoreId =3 AND Value=1)

edited Aug 7, 2012 at 11:19

answered Aug 7, 2012 at 11:11

omggs

1,1532 gold badges11 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to form this SQLite query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related