Re: Multiplying Records

anonymous_at_discussions.microsoft.com
Date: 03/11/04 

Date: Thu, 11 Mar 2004 15:56:57 -0800

>-----Original Message-----
>Please post the SQL of your query.

This gives me 346 records:
SELECT RawReport.Name AS Expr1, Units.[Unit Name]
FROM RawReport INNER JOIN Units ON (RawReport.Div =
Units.Division) AND (RawReport.Unit = Units.[Unit Code])
GROUP BY RawReport.Name, Units.[Unit Name]
ORDER BY RawReport.Name;

This gives me 1117:
SELECT RawReport.Name AS Expr1, Units.[Unit Name], Shifts.
[Shift Name]
FROM (RawReport INNER JOIN Units ON (RawReport.Div =
Units.Division) AND (RawReport.Unit = Units.[Unit Code]))
INNER JOIN Shifts ON (RawReport.Shift = Shifts.[Shift
Code]) AND (RawReport.Div = Shifts.Division)
GROUP BY RawReport.Name, Units.[Unit Name], Shifts.[Shift
Name]
ORDER BY RawReport.Name;

I tried making an outer join but kept getting something
about "ambiguous" outer joins. Didn't understand the help
screen about this, either.

Thanks.

Alan

Relevant Pages

  • Re: Query requesting parameter value twice
    ... FROM Shift INNER JOIN (Department INNER JOIN Employees ON ... capture the date input and funnel that into Expr1 to accomplish this. ...
    (microsoft.public.access.formscoding)
  • Query requesting parameter value twice
    ... FROM Shift INNER JOIN (Department INNER JOIN Employees ON ... capture the date input and funnel that into Expr1 to accomplish this. ...
    (microsoft.public.access.formscoding)
  • And , between and or
    ... Expr1, dbo_log_driverlogs.log ... FROM dbo_log_driverlogs INNER JOIN dbo_manpowerprofile ON ... Heres the query, it does ok until I put the Or statement in, then it returns ... and the boss is all I got and he is yelling. ...
    (microsoft.public.access.queries)
  • Still need help with multiplying records
    ... SELECT RawReport.Name AS Expr1, Units., Shifts. ... FROM (RawReport INNER JOIN Units ON (RawReport.Div = ...
    (microsoft.public.access.queries)
  • Re: query multi tables, count/sum 1 of the tables
    ... >I'm quering about 5 tables using inner join. ... >want to count or sum up the results. ... INNER JOIN Units ...
    (microsoft.public.sqlserver.mseq)