The Weird and The Wonderful

select 
sat.salesnumber,
pjq.pickjobnumber
 
from
 
(select salesnumber, rownumber, invoiceaccount
from salestable
where dataset = 'wtl'
and ltrim(salesnumber) = '331299') as sat
 
join
 
(select * from 
pickjobtrans) as pjt
 
on sat.rownumber = pjt.picksalesrecid
 
join
(select * from
pickjobqueue) as pjq
 
on pjt.pickjobnumber = pjq.pickjobnumber
group by sat.salesnumber, pjq.pickjobnumber
</code>

select distinct pjq.accountnumber,pjq.status
from pickjobqueue pjq
right join pickjobtrans pjt
on pjq.pickjobnumber = pjt.pickjobnumber
right join salestable sal
on pjt.picksalesrecid = sal.rownumber
where ltrim(sal.salesnumber) = '331299'
</code>

DoSomething(Text *text_store, int seven)<br />
{<br />
   char *text;<br />
   text = (char*) malloc(sizeof(char) * seven);<br />
//more code<br />
   text_store.title = text;<br />
   free(text);<br />
} <br />

for(int nindex = MIN_VAL; nindex <= MAX_VAL; nindex++);<br />
{<br />
  //50 lines of code that processes something<br />
}