Forums
This topic is locked
how do I create RS from 2 tables .....
Posted 27 Oct 2003 10:21:26
1
has voted
27 Oct 2003 10:21:26 Jared Sutherland posted:
I need to create a recordset or use a query so I can pull record details from one table and images from another table. I keep getting multiples of the same record for each of the images. Please help! Replies
Replied 14 Nov 2003 11:06:54
14 Nov 2003 11:06:54 Martin Scullion replied:
Depends on how the tables are set up using the DISTINCT clause in your sql statement might do it :-
ie Select Distinct field1 from table
will returns only distinct occurences of field1
If this doesn't help then describe how the tables are set up and I'll advise further
ie Select Distinct field1 from table
will returns only distinct occurences of field1
If this doesn't help then describe how the tables are set up and I'll advise further