I am facing problem in joining two tables for print session using report genetrator. Pls help.

Hi,

Please put your code so that people can help you.

I will give an example:-


Following code prints all the items from tcibd001 with item group descriptions from table tcmcs023

select tcibd001.item ,
tcibd001.citg,
tcmcs023.dsca
from tcibd001,tcmcs023
where tcibd001.citg refers to tcmcs023
selectdo
rprt_send()
endselect

Following code prints all the receipt transactions in warehouse ABC for all the items:-
select tcibd001.*
from tcibd001
selectdo
db.set.to.default(twhinr110)
select whinr110.*
from whinr110
where whinr110._index1 = :tcibd001.item
and whinr110.cwar = "ABC"
and whinr110.kost = tckost.receipt
selectdo
rprt_send()
endselect
endselect

Apart from this, you can use aliases if you want to query the same table. Please search the board for similar thread.