Join not allowed sql server , need a replacement query...
Posted on 2006-11-04
I need to run this query as shown below....
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
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...