sql queries in codesmith generator

Question

I am using codesmith generator .controllers are created by default now i want to use join queries . how can i write join queries in codesmith generated code.

i want to call that join queries using controller.

 

 

 

Can anyone help me????