Complicated SQL SELECT Statement - NEWBIE

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Oct 2007
Posts: 3
Reputation: punkazz is an unknown quantity at this point 
Solved Threads: 0
punkazz's Avatar
punkazz punkazz is offline Offline
Newbie Poster

Complicated SQL SELECT Statement - NEWBIE

 
0
  #1
Oct 4th, 2007
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!
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



Tag cloud for MS SQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC