Sure. My query looks like this: SELECT [xx.xxx.xx.xxx].Snowline.dbo.Street.RecordID, [xx.xxx.xx.xxx].Snowline.dbo.Street.Prefix + ' ' + [xx.xxx.xx.xxx].Snowline.dbo.Street.Name + ' ' + [xx.xxx.xx.xxx].Snowline.dbo.Street.Type + ' ' + [xx.xxx.xx.xxx].Snowline.dbo.Street.Suffix AS Name FROM Bus_Routes INNER JOIN [xx.xxx.xx.xxx].Snowline.dbo.Street ON Bus_Routes.Main_St_ID = [xx.xxx.xx.xxx].Snowline.dbo.Street.RecordID WHERE Bus_Routes.Route_ID = @Route_ID
What I was doing was on the inner join, I had it written like this: INNER JOIN [xx.xxx.xx.xxx].Snowline.dbo.Street.RecordID rather than INNER JOIN [xx.xxx.xx.xxx].Snowline.dbo.Street. Stupid mistake. This is what happens when you use the Create New View gui for so long, that when you have to write it out from scratch you forget the little things like that. The only problem now though is that I am not able to bind the individual fields. When I do a SELECT * then it works fine, but as you can see I am building a string so I need to reference the individual fields. Bruce Sorge ----- Original Message ---- From: Ian Skinner <[EMAIL PROTECTED]> To: SQL <[email protected]> Sent: Thursday, October 4, 2007 10:48:03 AM Subject: Re: Linked SQL Server question Bruce Sorge wrote: > Disregard. I figured it out. Can you share an example for those of us who may run into this in the future? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2970 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
