subquery is not the only way.
u can simply create another query and fetch the data from the other table.
alternatively u can also use data tables...