null value in query

[renante]

guys,
I was trting to merge records from mytwo table, cash voucher transaction and journal vouher transaction, each table have a account code column. i want to merge them in query where the records from the 2 records where all the records will be group together with account code. I have tried merging the records but reccords from cash voucher appears twice. All i wat is the two table to merge.
what can i do?

thanks guys

 

[RJFost]

Sounds like you need an INNER JOIN clause:

SELECT <fields>
FROM CashVoucher INNER JOIN JrnlVoucher
ON CashVoucher.AccountCode = JrnlVoucher.AccountCode

That'll limit your return set to only those records where the account code value in both tables is equal.