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. :)
pritaeas
2,000
It's a little vague. What are you trying, and what doesn't work?
Unimportant
18
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.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.