Questions tagged [multi-table]
138 questions
-2
votes
1 answer
Get count and sum of one table based on other table based on other table
I have 3 SQLite tables:
channel
channelId triad
1 1
2 1
3 0
video
channelId videoId topic
1 xx 1
1 yy 0
2 pp 0
3 kk 1
comment
commentId replyId videoId sentiment
NULL …
Vega
- 2,661
- 5
- 24
- 49
-2
votes
4 answers
How can I format column spacing for Multi Table?
I'm currently trying to use java to make a multitable with the following output:
0 1 2 3 4 5 6 7 8 9
+------------------------------
0| 0 0 0 0 0 0 0 0 0 0
1| 0 1 2 3 4 5 6 7 8 9
2| 0 2 4 6 8 10 12 14 16 18
3| …
HenryLau_123
- 3
- 3
-2
votes
1 answer
Retrieve PRIMARY KEY value from SELECT DISTINCT with INNER JOIN
I have a set of joined tables that I am querying in the following way:
$query = $this->mysqli->query("
SELECT DISTINCT name, website, email
FROM sfe
INNER JOIN ef ON sfe.ID_SFE = ef.ID_SFE
INNER JOIN f ON f.ID_F = ef.ID_F
…
s coronado
- 3
- 2