Alternative to Distinct

  • Thread starter Thread starter Ramaprasad via AccessMonster.com
  • Start date Start date
R

Ramaprasad via AccessMonster.com

Hello all, Thanks in advance. I have a problem of taking distinct values
from two tables where there are almost 30000 similar records and some are
varied. I tried using Distinct which will not execute. I tried using joins
which will give the repeated values for 60000 times. But my requiement is
to get it only once
 
You're going to have to give more details. What do you mean by "will not
execute"?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SELECT DISTINCT (multiple columns/tables) 7
SELECT DISTINCT query 8
Count distinct values 4
Create a distinct Join 3
Showing Distinct Values on a Sheet 1
DISTINCT in a crosstab query? 5
Query structure and distinct 7
Distinct Counts for multiple records in a group.. 1

Back
Top