General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
i have three table
TB_GLTRANS (id int,origin c(20),acc_per int,acc_year int) , TB_GLTRANSD (id int,idaccount int,mnt_cre n(8,2),mnt_deb n(8,2)) and i got the account table TB_GLACCOUNT(id int,accountno c(10))
I want to make a select but im not sure how to do it. For the result i want all the account with all the transaction(TB_GLTRANSD) for a determined acc_per and acc_year. So a account who does have a transaction i want to see it in the list.
So the result must be TB_GLACCOUNT.id,TB_GLACCOUNT.accountno,TB_GLTRANS.id,TB_GLTRANS.acc_per,TB_GLTRANS.acc_year,
TB_GLTRANSD.MNT_CRE,TB_GLTRANSD.mnt_deb
Thanks you
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only