Skip to content

Query: Ignition Custom Item LookUp

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

Tables Referenced

  • dbo_Lookups

Columns Selected

  • id
  • ShortNme
  • Grp
  • Id
  • ValLnk1

Where Clause

(((dbo_Lookups.Grp)=211))

SQL

SELECT dbo_Lookups.id, dbo_Lookups.ShortNme, dbo_Lookups.Grp, dbo_Lookups.Id, dbo_Lookups.ValLnk1 FROM [dbo_Lookups] WHERE (((dbo_Lookups.Grp)=211))