SQL topic 6


#1

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


#2

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'


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.