Hi Edward,
(see below)
Edward Corbett wrote:
Hi,
I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table t
Hi,
I hope this finds itself as an answer to my last post. I'm new to this email
message format of lists.
It turns out that the problem with the join was that I had a column being
selected that I removed from my posting example for brevity which was
causing the select to fail. The extra c
Hi,
I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table to 4 other tables. The query I have so far is bel
Martin Gainty wrote:
Good Morning-
Good afternoon :-)
http://www.mysqlperformanceblog.com/2006/09/04/group_concat-useful-group-by-
extension/
I did'nt see your where clause ?
I'm probably missing your point here. But there's no "where clause"
because I want all records from the tickets tab
Baron Schwartz wrote:
I'm tempted to solve this using a view or two, but would like to know
if there's a better way.
GROUP_CONCAT() takes an optional DISTINCT modifier, and that might do
what you're looking for.
It sure does the trick. I'll use that, I was afraid that I was missing
somet
Hi,
Morten wrote:
Hi,
I'm trying to write a query which returns a single record which contains
concatenated values for referencing records:
SELECT tickets.id AS id,
CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags,
CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CH
Hi,
I'm trying to write a query which returns a single record which contains
concatenated values for referencing records:
SELECT tickets.id AS id,
CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags,
CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CHAR) AS text
FROM tic
-Original Message-
From: Aleksandar Bradaric [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 3:32 PM
To: Ján Fedorek
Cc: MySQL List
Subject: Re: LEFT JOIN trouble. Please help.
Hi,
> I have two tables and I want create third one with LEFT JOIN
> First table
Hi,
> I have two tables and I want create third one with LEFT JOIN
> First table table1 containts field AA as a primary key (AA is NOT NULL).
> Second table table2 containts field AA as a primary key (AA is NOT NULL)
> too.
> Ex:
> CREATE TABLE a (PRIMARY KEY(AA))
> SELECT table1.AA FROM table2
Hi,
I've got this problem:
I have two tables and I want create third one with LEFT JOIN
First table table1 containts field AA as a primary key (AA is NOT NULL).
Second table table2 containts field AA as a primary key (AA is NOT NULL)
too.
Ex:
CREATE TABLE a (PRIMARY KEY(AA))
SELECT table1.AA F
our command was trying to churn out 8077 * 8077 = 65,237,929 rows each with
298 columns. No wonder it took a long time.
Regards
Quentin
-Original Message-
From: Paul Krohn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 14:06
To: [EMAIL PROTECTED]
Subject: JOIN trouble
hi t
hi there. i've just joined the list. I took a look through the archives
and I think I've got the whole concept of JOIN wrong, but here goes.
Here's the task: I've got three tables, each with the same number of
records (8077, fwiw). they have 149, 149, and 80 columns.
There are a few columns th
12 matches
Mail list logo
