I have two tables with, say, 10 records in each. I'm trying to display those 10 records from each table on the same raw in a list box:
column 1 column 2 column 3
raw 1 FirstName (table 1) LastName (table 1) Contacted (table 2) and so on.

I tried running a select query but what happens is that for each record (raw) in table 1 list box displays all 10 records (raws) from table 2. So I have 100 line tolal instead of 10.

Any ideas anybody? thanks.