Select multiple tables (normal approach)
example SELECT name , price , photo FROM drinks , drinks_photos WHERE drinks . id = drink_photos.drinks_id https://stackoverflow.com/questions/12890071/select-from-multiple-tables-mysql
Posts
Mysql having clause
The SQL HAVING Clause The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. HAVING Syntax SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) HAVING condition ORDER BY column_name(s); Resource: https://www.w3schools.com/sql/sql_having.asp
Tutorial OOP(reversion java)
Reversion exercise for java. Please answer all questions in paper. Without using IDE. 30 minutes is allocate for this exercise. Get the questions in the link below. Java Reversion Exercise emailkan ke: arizalshamsil89@gmail.com subject: OOPReversion(no Matrik)
mysql function
Click this link to view the lists of mysql function https://www.w3schools.com/sql/sql_ref_mysql.asp