February 17th, 2012, 05:58 AM
Left Join two dependent tables
Hi, I have some problem with joining two dependent tables... I need to do this:
I have an error "numeric overflow" when there is no t2 table record... so in that case how to Select 'No data' from t3 where there is no t2 record? I mean 't3.Id_t3 = t2.Id_t2' shouldn't be taken when there is no t2 record... how to do this?
coalesce(t3.Data,'No data') AS Data
LEFT JOIN t2 ON t2.Id_t2 = t1.Id_t1
LEFT JOIN t3 ON t3.Id_t3 = t2.Id_t2
Thanks for any help!
February 20th, 2012, 12:58 AM
What type is t3.data?
If is not character than that is causing the error.