Help with SQL statement

  • Thread starter Thread starter Lewis Jones
  • Start date Start date
L

Lewis Jones

Hi,

I want to include the following SQL statement (copied
from a query) in an event procedure but I'm not clear on
the right syntax.

Can anyone help?


SELECT MatchCategory.MatchCategoryID
FROM (MatchType INNER JOIN Match ON MatchType.MatchTypeID
= Match.MatchTypeID) INNER JOIN (MatchCategory INNER JOIN
MatchTypeDetails ON MatchCategory.MatchCategoryID =
MatchTypeDetails.MatchCategoryID) ON
MatchType.MatchTypeID = MatchTypeDetails.MatchTypeID
WHERE ((([Match]![MatchID])=[Forms]![Heat]![MatchID]));


Thanks

Lewis
 
Include it in an event procedure for what purpose? Please give us more
information.
 
Back
Top