Hi ALL!
    I have a problem with this query, because it keeps failing and I dont
know why (it says that the concat statement is wrong but there is nothing on
the online docs...)

select st.id, concat(st.required), st.name from states st, agenda ag left
outer join ag.id=concat("AGE",st.required)  where st.type='AGE' and st.id>0;

in this st.required is an int(7) and ag.id is a varchar(40).
Thanks
Leo.

Mysql sql query select,


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to