Question: Create the below Queries: table [ [ Query # , Query Name,Query Fields,Table ( s ) , Other ] , [ Query 1 ,
Create the below Queries:
tableQuery #Query Name,Query Fields,TablesOtherQuery All Users,All fields,Users,naQuery All Chats,All fields,Chats,natableQueries tableQuery Names:Session Session etctableChatIdSessionfromUsertoUsermessageChats,tableList in sequence by ChatId.Enter criteria for Sessionfield for each sessionnumber in queries.Query Donna,tableChatIdSessionfromUsertoUserChats,tableList in alpha order by thetoUser and then by ChatIdQuery Peter,tablefromUsertoUsermessageTimemessageChats,tableInclude only messagesfrom Donna and JohnSort by message time fromlongest to shortest. Do notdisplay the message time.Query John,tableusernamemessagestoUsertableUsersChatstableList all messages sent by JohnSmith and sequenced bytoUser Should have join.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
