Leonardo Javier Bel? wrote:
>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;
>
>
Did you mean:
select st.id, concat(st.required), st.name from states st left join agenda ag
on 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]
