If you're asking if it will work, sure, probably. ;)
I assume you only have one record in that table. What you will find is that if there are two records, it will double the number of records returned by this query. If there are 3 it will triple, and so on. An unjoined table will produce a Cartesean product.
Paul
--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
>
> I have an Access front end on a server on the internet. Members read
> the ASP pages which have been made by a code generator.
>
> I experimented with this SQL because I needed the "Rate" in the
> "tServiceRate" table to be variable without changing the code in the
> query. I provide the administrator with an interface to the
> "tServiceRate" table on line.
>
> My tests have worked. Is this a documented technique that I can
> reference somewhere? Are there any possible problems?
>
> SELECT tServiceProjects.ProjectID, tServiceProjects.MonthID,
> tReportMonth.ReportMonth, tReportMonth.MonthDate,
> tServiceProjects.ClubID, tServiceProjects.Description,
> tServiceProjects.SumDonated, tServiceProjects.MembersInvolved,
> tServiceProjects.TotalHours, [TotalHours]*[Rate] AS ServiceValue,
> [SumDonated]+[ServiceValue] AS Total
> FROM tServiceRate, tServiceProjects INNER JOIN tReportMonth ON
> tServiceProjects.MonthID = tReportMonth.ReportMonthID;
>
> Many thanks,
>
> Robin Chapple
>
Tidak ada komentar:
Posting Komentar