Query Two Tables

[zyus]

I have this two tables

Tbl A
ACNO Netbal
123 500.00

Tbl B
ACNO TRNCODE Amt
123 STM 100.00
123 Ist 200.00

How to make a query in these two tables link by ACNO so i can get one row of
record as per below:

ACNO Netbal TrnCode Amt TrnCode Amt
123 500.00 STM 100.00 Ist 200.00

Thanks

 

[Arvin Meyer MVP]

Since TrnCode and Amt are the same field, you cannot use them twice in the
same query with different data. If the data in table B occurs a multiple
times you could count the records and build a temporary table with the
maximum number of rows, appending the data in code to that temporary table,
by walking a recordset.