I need to take value from 3 tables.
Right now i am trying to pick value from 2 tables.
Below is the query for that
now i need to pick the value from one more table whose num is the same as tableB 's num
if i do this i am not getting any value for the age eventhough there is some value for that particular num.
what i all need is to select the age from tableC and display it.
Is there any other way of written this query.
thanks in advance.