Member Avatar for Zdneth_1

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
  • 2 Replies
  • 130 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Unimportant
Member Avatar for pritaeas

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

Member Avatar for Unimportant

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.