SQL Select with variables (merged by CM) [message #444562] |
Mon, 22 February 2010 10:13 |
jfavelle
Messages: 2 Registered: February 2010
|
Junior Member |
|
|
Having trouble with my variables in this staement.
Thanks In Advance
SELECT WP_USERS.F_NAME || ', ' || WP_USERS.L_NAME AS NAME, WP_PROJECTS.TITLE, WP_PROJECTS.CLIENT_MANAGER,
WP_PROJECTS.PERSON_DAYS
FROM WP_PROJECTS, WP_PROJECTS_USERS, WP_USERS
WHERE WP_PROJECTS.PROJECT_ID = WP_PROJECTS_USERS.PROJECT_ID AND WP_PROJECTS_USERS.USER_ID = WP_USERS.USER_ID AND
WP_PROJECTS_USERS.USER_ID = WP_USERS.USER_ID AND (WP_PROJECTS.SITE = "@SITE") AND (WP_PROJECTS."SECTION" = '@SECTION')
[Updated on: Mon, 22 February 2010 10:36] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|