We help IT Professionals succeed at work.

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

coastman14
coastman14 asked
on
Medium Priority
262 Views
Last Modified: 2011-09-20
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...
Comment
Watch Question

Top Expert 2006
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.