Skip to content

Query: JB Qry Append Proposal Writers

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

Tables Referenced

  • Proposal

Columns Selected

  • Proposal.[Writer Name]
  • Proposal.[Writer Name Other]
  • Proposal.[Writer Role]
  • Proposal.[Writer Role Other]
  • Proposal.[Proposal ID]

Where Clause

(((Proposal.[Writer Name]) Is Not Null))

SQL

SELECT Proposal.[Writer Name], Proposal.[Writer Name Other], Proposal.[Writer Role], Proposal.[Writer Role Other], Proposal.[Proposal ID] FROM [Proposal] WHERE (((Proposal.[Writer Name]) Is Not Null))