SQL topic 6

[seksit]

select
*
from
albums
left join artists on
albums.artist_id=artists.id
Select
albums.name as ‘album’
albums.year,
artists.name as ‘artist’
from
albums
join artists on
albums.artist_id=artists.id
where
but they didn’t run . what can i do? please help…
seksit

[rcodeman]

Select
  albums.name as 'album'
  albums.year,
  artists.name as 'artist'
from
  albums
join artists on
  albums.artist_id=artists.id
where

you didn’t complete the query .
where(last line) ???

also you need a , after this line

albums.name as 'album'