[SOLVED] Nightmare query

This is a discussion on "[SOLVED] Nightmare query" within the Databases section. This forum, and the thread "[SOLVED] Nightmare query are both part of the Program Your Website category.



 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1  
Old Nov 17th, 2007, 15:50
Highly Reputable Member
Join Date: Jul 2006
Location: Devon, England
Posts: 565
Thanks: 0
Thanked 0 Times in 0 Posts
[SOLVED] Nightmare query

I'm having a nightmare with a query and i can't make it work

I want to select all employee_ids who manages a department with more than 5 employees

Employee table
-------------------
employee_id (primary key)

Manages table
------------------
employee_id (foreign key)
dept_id (foreign key)

Department table
----------------------
dept_id (primary key)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
[solved] Menu Nightmare saltedm8 Web Page Design 3 Apr 14th, 2008 22:35
[SOLVED] Query postcode issue? meth8200 Databases 9 Feb 25th, 2008 12:21
[SOLVED] Mysql Query not working nate2099 Databases 13 Jan 3rd, 2008 02:28
[SOLVED] Partial Search Query Aerdan Databases 5 Nov 7th, 2007 15:26
[SOLVED] asp / sql query Anonymous User Classic ASP 4 Nov 19th, 2004 08:39


All times are GMT. The time now is 06:14.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42