Query Two Tables

  • Thread starter Thread starter zyus
  • Start date Start date
Z

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
 
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.
 
Back
Top