Share
Explore BrainMass

SQL Queries Exercise

As an exercise, which if you choose to accept,. Let's say we have the following tables with columns as such:

COURSE

COURSE COURSE COURSE DEPT
CODE NAME OFFERED CODE

POS410 SQL for Business Online IST
DBM380 Database Concepts Online IST
BUS101 Business Concepts Class BUS

DEPT

DEPT DEPT
CODE NAME
IST Information Systems and Technology
BUS Business

If I wanted to get the output to look as follows:

SQL for Business Information Systems and Technology Online

What would my query look like? Although you don't need to build any tables with data, it would help to do this so you can test your sql query. In order to better understand sql you need to practice writing sql.

Attachments

Solution Summary

This solution deals with a SQL query for related to courses and departments.

$2.19