Ask a Question related to Coldfusion Database Access, Design and Development.
-
BenAmy #1
Query without Nested
How to rewrite this query with out nested select statments ?
SELECT employee_name
FROM employees
WHERE employee_key IN (
SELECT employee_key
FROM employee_departments
WHERE department_key IN (
SELECT department_key
FROM departments
WHERE department_name = 'Sales'
)
)
Please help me in this regard.
Thanks
Amy
BenAmy Guest
-
Nested query results
Hello I'm sure this question is quite common, would be very grateful for any guidance. I have an access database, which contains two tables:... -
Query of Queries on query New type query
In CF5 we have a page that creates a query, using queryNew and querySetCell and the like, we then used dbtype="query" and gave it's name so we could... -
Convert a query to a list, or find an item in a query
Hi All, I am using CFPOP to retrieve mail from a server, then delete each message after I retrieve it. What I want to do is to check that I don;t... -
CAML Query: Multiple Query Fields Issue
I need to Create a CAML Query Dynamically with VB to a Sharepoint WebService GetListItems Method. The User Could Select 1 to X Number of IDs... -
BCP query out executed by xp_cmdshell works fine from query analyzer but fails from VB Component
Hi all, I have a stored procedure which returns a vast number of record and i have to write the output into a csv file. I'm using BCP utility to... -
mxstu #2 Re: Query without Nested
Something like this... but the exact syntax depends on your database type
--- Not tested
SELECT e.employee_name
FROM employees e INNER JOIN employee_departments ed ON e.employee_key =
ed.employee_key
INNER JOIN department_key dk ON ed.department_key =
dk.department_key
WHERE dk.department_name = 'Sales'
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
