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

Edited by JamesCherrill: Moved to a more appropriate forum

3
Contributors
2
Replies
10
Views
3 Years
Discussion Span
Last Post by Unimportant
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;
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.