Posted by GarryJones on 12/11/06 17:22

I think the following statement ....

$ml_collect='SELECT *, DATE(CONCAT(field1, field2)) AS thedate FROM
ml_lopp LEFT JOIN scfmforening ON (scfmforening.scfmnum =
ml_lopp.scfmnum) LEFT JOIN ml_tidplats ON (ml_tidplats.loppnum =
ml_lopp.loppnum) ORDER BY thedate';

.....would work if "field1" and "field2" were in the table "ml_lopp"

However, "field1" and "field2" are in the table "ml_tidplats" and
accessed by "LEFT JOIN".

So, how do I use "DATE(CONCAT(field1, field2))" in this case?

Garry Jones
Sweden

• Next in forum: Re: Concat in a join?
• Prev in forum: Re: faster way to get from SQL database into array
• Thread view: Concat in a join?

[Reply to this message]