|
|
#1 |
|
Senior Member
![]() Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
|
Anyone with android development skills?
How do you make a join of 2 tables?
Simple example: table A column1 column2 table B columnx columny how do I join column1 and columny? tia. |
|
|
|
|
|
#2 |
|
Member
![]() Join Date: Oct 2010
Location: In LVL1
Posts: 325
Likes: 13
Liked 65 Times in 35 Posts
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
|
public Cursor rawQuery (String sql, String[] selectionArgs)
rawQuery("select t1.column1 , t2.columnY from table A t1 join table B ON (.....)",null);
__________________
Playstation 3 SLIM 120GB JB
Rogero 4.30 CFW MultiMan [Latest Version] |
|
|
|
|
Likes: (1) |
|
|
#3 |
|
Senior Member
![]() Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
|
thanks but why a cursor?
|
|
|
|
|
|
#4 |
|
Senior Member
![]() Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
|
What are to using to build the apps? Eclipse with java?
__________________
![]() |
|
|
|
|
|
#5 |
|
Senior Member
![]() Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
|
|
|
|
|
|
|
#6 |
|
Senior Member
![]() Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
|
Just wondering what you mean by joining 2 tables ?
__________________
![]() |
|
|
|
|
|
#7 |
|
Senior Member
![]() Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
|
is there other way to do it?
|
|
|
|
|
|
#8 |
|
Senior Member
![]() Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
|
Do you mean on the layout screen , can't you use place holders for them? Can you explain what your trying to do?
__________________
![]() |
|
|
|
|
|
#9 |
|
Senior Member
![]() Join Date: Aug 2011
Posts: 1,270
Likes: 179
Liked 840 Times in 392 Posts
Mentioned: 61 Post(s)
Tagged: 0 Thread(s)
|
I’m trying to make an app with several functionalities and I need to store data. Right now I’m focused in the data model, that’s why I’m trying to understand how to make the queries.
|
|
|
|
|
|
#10 |
|
Senior Member
![]() Join Date: Dec 2010
Location: Wales
Posts: 1,297
Likes: 40
Liked 388 Times in 253 Posts
Mentioned: 54 Post(s)
Tagged: 0 Thread(s)
|
Well you need to use a database I would of thought ?
__________________
![]() |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
|
|