Dynamic Test

{tbs}mergeblock=u;sql=SELECT id, name, email FROM jos_users where id=65{/tbs}
NameEmailID
[u.name;block=tr][u.email][u.id]  

{tbs}mergeblock=k;sql=SELECT id, name, email FROM jos_users ORDER BY name{/tbs}
NameEmailID
[k.name;block=tr][k.email][k.id]  

{tbs}embedded{/tbs}
[m.name;block=tr]