Queries

[Guest]

I am trying to build a query that pulls data from two tables. One table
(sales) has records (879A and 879B). the other table (errors) has records
(879). I accumualte information for both (sales entries in the errors
tables). I only need to see (879) once but I get (879, 879). I display some
other fields from the sales table. Can you help me with this query:

SELECT [error-stats].[bid-number], [error-stats].[number-errors],
[error-stats].[total-cost], sales.[job-name]
FROM [error-stats] LEFT JOIN sales ON [error-stats].[bid-number] =
sales.[bid-number]
ORDER BY [error-stats].[bid-number];

 

[Guest]

If the duplicate records are identical you could try adding Distinct after
the select

like: SELECT distinct [error-stats].[bid-number], etc....

hth