Posted by Andy Hassall on 12/11/06 17:46

On 11 Dec 2006 09:22:59 -0800, "GarryJones" <morack@algonet.se> wrote:

>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?

What happened when you tried it?

It looks like you're using MySQL, so the question would be more topical on
comp.databases.mysql.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]