Solved

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

Posted on 2006-11-04
1
247 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...
0
Comment
Question by:coastman14
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 35

Accepted Solution

by:
Raynard7 earned 175 total points
ID: 17874958
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

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question