Skip to content

Query: Guide Management

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • dbo_Lookups

Columns Selected

  • Id
  • Nme
  • ShortNme
  • ValLnk3
  • ValLnk2
  • Sorting
  • Grp
  • Id
  • ValLnk1

Where Clause

(((dbo_Lookups.Grp)=216))

SQL

SELECT dbo_Lookups.Id, dbo_Lookups.Nme, dbo_Lookups.ShortNme, dbo_Lookups.ValLnk3, dbo_Lookups.ValLnk2, dbo_Lookups.Sorting, dbo_Lookups.Grp, dbo_Lookups.Id, dbo_Lookups.ValLnk1 FROM [dbo_Lookups] WHERE (((dbo_Lookups.Grp)=216))