944,198 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 2584
  • MS SQL RSS
Oct 4th, 2007
0

Complicated SQL SELECT Statement - NEWBIE

Expand Post »
It's me again...the newbie. I have a web application that I am developing for a school project. Quick overview; the user submits one of multiple different types of "requests" and then a technican begins work on the project. Anyway; with the help of others I have gotten the EXTREMELY long insert query complete and functional. My next step is to pull data for the "home page". The home page will show users a "summar" of requests that their name is associated to but is also (obviously) based on who is logged in. Anyway; I have created this query but it is returning NOTHING so I know it's not right but I'm not sure where I messed up...even though the query may not be done in the best manner this is all the data that i would need from my tables.

SELECT Project.ProjectID, RequestorName, BusinessUnitName, ProjectTypeName
FROM Project,Requestor,BusinessUnit,ProjectType, aspnet_Users, ProjectTechs
WHERE (Project.RequestorID = Requestor.RequestorID
AND Project.BusinessUnitID = BusinessUnit.BusinessUnitID
AND Project.ProjectTypeID = ProjectType.ProjectTypeID)
AND aspnet_Users.DisplayName = Requestor.RequestorName
OR aspnet_Users.DisplayName = ProjectTechs.UserId

Thank you; in advance!
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
punkazz is offline Offline
3 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: help with paging in sql 2000
Next Thread in MS SQL Forum Timeline: datetime decrement





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC