Hi

Thanks, now it's working. I'm using a right outer join with ROW_NUMBER.

Regards

Fia

Hi again

It works, thanks. But what if I also want to get the rows that doesn't have any images, meaning the rows from tblVara that doesn't have fldVaraID in table...

Hi

Thanks for your reply.

The tblVara has:

fldVaraID int identity

fldKategori int

fldRubrik nvarchar

fldText nvarchar

fldPris int

The tblImage has:

fldVaraID int which is a foreign key to tblVaraID.fldVaraID

fldImage image

fldImageID int identity

It is between these tables...

Thank's

For the help:-)

Fia