WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

I need help with using MATERIALIZED VIEW.

TangledPubes

New member

0

0%

Status

Offline

Posts

39

Likes

0

Rep

0

Bits

205

8

Months of Service

0%
Hello valued members, I need to solve a question but I am having trouble. The question is as follows: I have 3 tables; user information is stored as follows: users email password register_date Meetings are stored in a table as follows: meetings meeting_id name time Information on meetings attended by a user is stored as follows: user_meetings user_meeting_id user_email meeting_id meeting_enter_time According to these tables, I need to write a Materialized view that keeps track of people who attended a meeting on that day. Is there someone who can write and share the SQL code for this? Thank you in advance to whoever responds.
 

254

6,645

6,665

Top