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]