Member Avatar

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. :)

Edited by JamesCherrill because: Moved to a more appropriate forum
  • 3 Contributors
  • forum 2 Replies
  • 106 Views
  • 1 Hour Discussion Span
  • comment Latest Post Latest Post by Unimportant

Recommended Answers

Answered by pritaeas 2,045 in a post from

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

Jump to Post

All 2 Replies

Member Avatar

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

Member Avatar

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;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!