HI SQL team,
I am new to SQL query so trying to explain as much as I can to resolve my problem.
I have to create a view based on below scenario .
TABLE 1 : COLUMNS1,COLUMNS2,STUDENT ID, ATTENDANCE PER CLASS ( student id can be repeated multiple time per attendance )
TABLE 2 : COLUMNS1,COLUMNS2, STUDENT ID,TOTAL ATTENDANCE
Now I need to create individual student id view where their total attendance which is higher then 10 and have that view all colume from table 1
Thanks in advance
Maulik