How to select specific column from multiple table in sqlite?

Question

I have two table's table as follows:

Names :-

id firstname lastname, address, phone

Now, i have another table which contains lets say location data for person's in first table

Location :-

id latitude, longitude

now , i have to select, firstname, latitude, longitude only using sql/sqlite query.

Currently, my query is :-

  Names nameTable INNER JOIN Location locationTable ON nameTable .id =locationTable .id WHERE nameTable .id=12

This query i use in android sqlite and it returns me full table.

I want specific columns only to increase performance. Can anyone help me with the query ?

SELECT Names INNER JOIN Location ON Names.id = Locations.id WHERE Names.id = 12 should work, if id is UNIQUE. — Phantômaxx
– Phantômaxx, Commented Oct 29, 2014 at 9:22

Westranger · Accepted Answer · 2014-10-29 09:33:20Z

4

This select statement should work:

SELECT n.firstname, l.latitude, l.longitude FROM Names n JOIN Location l ON n.id = l.id WHERE n.id=12

I usually use SQLLiteBrowser (or something similar) which allows you to load your database and to execute SQL queries on it. This way you can test your statements befor putting them unto you code.

edited Oct 29, 2014 at 9:33

answered Oct 29, 2014 at 9:27

Westranger

1,36721 silver badges33 bronze badges

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

1 Comment

Westranger Over a year ago

If this answer helped you to solve your problem please accept the answer! Thank you very much

Collectives™ on Stack Overflow

How to select specific column from multiple table in sqlite?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related