Members
The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership.
Write a SQL SELECT statement that allows the user to provide a specific MemberID. The query should select all fields.

Question

Members 
The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. 
Write a SQL SELECT statement that allows the user to provide a specific MemberID. The query should select all fields.

Quizplus · Accepted Answer

The Answer of Members 
The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. 
Write a SQL SELECT statement that allows the user to provide a specific MemberID. The query should select all fields.

Members the TblMembers Table Contains Six Fields. the LastName, FirstName, and FirstName