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 Matthew,
There are several combination of things you can query for with the data you
have: Only Products with Tags, Only Tags with products, all Products with
or without Tags, all Tags with or without Products
However you do not have the ability (yet) to query, in a single statement,
for
Matthew Shalorne wrote:
Hi,
with the tables eg:
Product: id, product, cost
ProductTag: productId, TagId
Tag: id, tag
I have created the ability to selectively assign tags to products if
required via a many-to-many relationship.
Now I want to join the tables in MySQL so that I can see all products
At 14:20 +0100 1/22/04, Frederic Wenzel wrote:
Mike Mapsnac wrote:
What is the difference between Left Join and Left Outer Join?
Thanks
If I get it right, there is none.
Greetings
Fred
You got it right. There is none.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB,
Mike Mapsnac wrote:
What is the difference between Left Join and Left Outer Join?
Thanks
If I get it right, there is none.
Greetings
Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:11 PM
To: Rob
Cc: [EMAIL PROTECTED]
Subject: Re: left outer join
Hi,
You have one thing wrong in your query...
You're using LEFT JOIN but then you use a condition over DFL in the
where clause. That's why it doesn't give you the results expec
EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:11 PM
To: Rob
Cc: [EMAIL PROTECTED]
Subject: Re: left outer join
Hi,
You have one thing wrong in your query...
You're using LEFT JOIN but then you use a condition over DFL in the
where clause. That's why it doesn't give you the results
I am not sure whether you have checked for case sensitive issues but it could be
that?
document_fields.id,document_fields_link.id
are you getting any errors?
Andrew
>SELECT DF.id, DFL.id
>FROM document_fields AS DF LEFT JOIN document_fields_link AS DFL on DF.id =
>DFL.document_field_id
>WHERE
Hi,
You have one thing wrong in your query...
You're using LEFT JOIN but then you use a condition over DFL in the
where clause. That's why it doesn't give you the results expected from a
LEFT JOIN.
You should have a look in the manual to see how to use left joins.
The query should by:
SELECT D
Arul,
Monday, July 01, 2002, 3:58:48 PM, you wrote:
A> Can i use left outer join in MySQL.
A> Like i have one condition in Oracle
A> ex:
A> select * from user,company where u.companyid = c.companyid (+)
A> can i rephrase the query in mysql like this
A> select * from user left outer join compa
You could try using the IFNULL() function on that column before you do the join.
http://www.mysql.com/doc/C/o/Control_flow_functions.html
--jfarr
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 11:12 AM
Subject: left outer
13 matches
Mail list logo
