-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Je ÄaÅdo Januaro 27 2005 08:40, Jigal van Hemert skribis:
> > Currently I have a query that is able to return (doing a left join):
> > 'A', 'B', 'E'
> > 'A', 'B', 'F'
> > 'C', 'D', NULL
> > But I need this:
> > 'A', 'B', 'E,F'
> > 'C', 'D', NULL
> > Ca
> Currently I have a query that is able to return (doing a left join):
> 'A', 'B', 'E'
> 'A', 'B', 'F'
> 'C', 'D', NULL
> But I need this:
> 'A', 'B', 'E,F'
> 'C', 'D', NULL
> Can SQL help me in any way here ? or do I have to do it by programming ?
If you use MySQL 4.1 or later take a look at
http
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm in need of doing the following.
I have a table, let's say, with a record like this:
1, 'A', 'B'.
2, 'C', 'D'
And then I have another table with records like this:
1, 'E'
1, 'F'.
Currently I have a query that is able to return (doing a left join):
'