Custom SQL Statement involving outerjoins and 3 tables
$30-5000 USD
Pagado a la entrega
A custom SQL statement that involves 3 tables. Song a, Artist b, and Album c. The relationships are are follows: a.artistid=[url removed, login to view] a.albumid=[url removed, login to view] There is a outerjoin and innerjoin. The innerjoin will be the song with the artist. However, the outerjoin is song with the album because if the album is not there, it will still show up but with a null value. The where clause will be deletethis=false It may involve subqueries. It should be commented so it can be reused.
## Deliverables
A SQL statement added to the program enclosed that is an innerjoin and outerjoin. Also the statement commented.
## Platform
Windows 98. Microsoft Access
Nº del proyecto: #2843163