Query: Qry Badges
Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No
Tables Referenced
- People
- Badge
- People Badges
Columns Selected
- People.[People ID]
- Badge.[Badge ID]
- Badge
- [People Badges].[Date Assigned]
SQL
SELECT People.[People ID], Badge.[Badge ID], Badge.Badge, [People Badges].[Date Assigned] FROM [People], [Badge], [People Badges]