Multiple where clause in sqlite3 in Android

Question

I'm struggling with sqlite query since 2 days in Android.

Here is details -

I've two table

localeResource
Banner table

Table structure is -

LocalResource - id, locale, key, value

Banner - bannerid, bannername, bannerimage, bannerlink, bannertext, countryid, bannerassociate

My query is like -

Working query -

select ban.bannerid,loc.value,ban.bannerimage,ban.bannerlink,ban.bannertext,ban.countryid,ban.bannerassociatedstyle from banner ban left outer join localeResources  loc on  loc.key = ban.bannername and loc.locale='FR';

But I wanted query like -

select ban.bannerid,loc.value,ban.bannerimage,ban.bannerlink,locs.value,ban.countryid,ban.bannerassociatedstyle from banner ban left outer join localeResources  loc, localeResources  locs on  loc.key = ban.bannername, locs.key = ban.bannertext and loc.locale='FR';

When I'm running second query my sqlite is hanging and crashing.

Please let me know what & where i'm missing.

What is the desired meaning? Must key match with both ban columns, or with one of them? — CL.
– CL., Commented Jun 14, 2014 at 7:47

Jens · Accepted Answer · 2014-06-14 07:52:17Z

1

Your query is wrong:

This one should work:

    select ban.bannerid,loc.value,ban.bannerimage,ban.bannerlink,locs.value,ban.countryid,ban.bannerassociatedstyle 
   from banner ban left outer join localeResources  loc on loc.key = ban.bannername and loc.locale='FR'
   left outer join localeResources  locs on  locs.key = ban.bannertext ;

You have the on statement at the wrong place.

answered Jun 14, 2014 at 7:52

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

2 Comments

Rakesh Over a year ago

Thanks Jens for your query, but it is showing duplicate value, and show ENG & French from outer side.

Jens Over a year ago

@Rakesh Can you add some sample data please?

Rakesh · Accepted Answer · 2014-06-16 05:39:42Z

0

Thanks Jens, based on your query, correct query is -

select ban.bannerid,loc.value,ban.bannerimage,ban.bannerlink,locs.value,ban.countryid,ban.bannerassociatedstyle from banner ban 
left outer join localeResources  loc on loc.key = ban.bannername and loc.locale='FR' left outer join localeResources  locs on  locs.key = ban.bannertext 
and locs.locale='FR';";

answered Jun 16, 2014 at 5:39

Rakesh

2,80032 silver badges28 bronze badges

Collectives™ on Stack Overflow

Multiple where clause in sqlite3 in Android

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related