Querying Tables Project 6/7


#1

Is this code correct? Nothing is coming up.

SELECT id
FROM artists
LEFT JOIN albums
ON artists.id = albums.artists_id;


#2

@bytemaster75485,
could provide the link to course/section


#3

@bytemaster75485,
You could try a refresh Browser....
and
read
http://stackoverflow.com/questions/4715677/difference-between-left-join-and-right-join-in-sql-server


#4

albums LEFT JOIN artists // (Shows all data from albums, possibly some data from artists)  
artists LEFT JOIN albums // (Shows all data from artists, possibly some data from albums)

In the instructions we can read, that we wanna have all data from albums and some Albums doesnt have artists. So which LEFT JOIN you should use here? :slight_smile:

And dont specifie the columns (use *).

I hope that would help you.


#5

SELECT * FROM artists
LEFT OUTER JOIN albums ON
artists.id=albums.artist_id;

does the job.