Join not allowed sql server , need a replacement query...

I need to run this query as shown below....

select
'/MediaDisplay/'+
right (convert(varchar(20), media.tableuid), 2) +
'/lr' + media.mediaSource as uri,
prp.acres, prp.bathsfull as bathroom, prp.bathshalf, prp.bed1dim, prp.bed2dim, prp.bed3dim, prp.bed4dim,
prp.mlsnum as lee2_id from prp
join media on media.mlsnum=prp.mlsnum
where listprice>0

However I get this error message:
Cannot specify outer join operators in a query containing joined tables. View or function 'tempo.dbo.dd_prp_flat' contains outer join operators.

I didn't write the views but I assume they have joins in them, how can i get this query working in another way...
coastman14Asked:
Who is Participating?
 
Raynard7Connect With a Mentor Commented:
select
'/MediaDisplay/'+
right (convert(varchar(20), media.tableuid), 2) +
'/lr' + media.mediaSource as uri,
prp.acres, prp.bathsfull as bathroom, prp.bathshalf, prp.bed1dim, prp.bed2dim, prp.bed3dim, prp.bed4dim,
prp.mlsnum as lee2_id from prp, media
where listprice>0 and media.mlsnum=prp.mlsnum
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.