View Single Post
  #63 (permalink)  
Old 08-27-2007, 08:16 AM
kingmaker kingmaker is offline
D-Web Genius
 
Join Date: Jun 2007
Posts: 882
kingmaker is on a distinguished road
Send a message via Yahoo to kingmaker
Question Re: ASP.NET Data Controls

hi guys,

I have my ODS in SP, I've problem to choose the column in the Table (the part which I bold the font below), it is syntax error.
Any comment? Thanks for helps..
SELECT
SampleToolItem .*,
Creators.UserName ItemCreatorDisplayName

FROM
SampleToolItem
INNER JOIN aspnet_users AS Creators ON Creators.UserId = SampleToolItem.ItemCreatorId
Where
SampleToolItem.@ddl = @tb
__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)
Reply With Quote