1,105,386 Community Members

JoinTables

Member Avatar
Zdneth_1
Newbie Poster
9 posts since Jul 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi Guys, I need some help about join queries in SQLite manager. I wanna have some sample queries on joining one or more tables with relationship of course. PLEASE I NEED THIS FOR OUR PROJECT. Thanks. It would be an honor hearing from professionals out there. :)

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

It's a little vague. What are you trying, and what doesn't work?

Member Avatar
Unimportant
Posting Whiz in Training
267 posts since Oct 2010
Reputation Points: 18 [?]
Q&As Helped to Solve: 54 [?]
Skill Endorsements: 9 [?]
 
0
 

Format
SELECT (column list)
FROM (primary table)
JOIN (seconary, tertiary, ...) ON (comparator)

SELECT a.column, a.nother,
       b.for, b.cause
FROM `table` AS a
JOIN `table2` AS b
ON a.id = b.id;
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: