Well, let me give the complete details
Let's say I have one table called events
with fields eventID and eventName
Then one table called djs
with fields djID and djName
And finally a table linking them all called eventdjs
with fields called eventID and djID
this table links one event with all the appropriate djs.
I use the same linking tables for outlets and other infos.. those are many
to many relations.
Now I want to select all djs from one event, this means taking info from
events and djs table, but using the 3rd table for the link.. that's what I'm
not able to do.
There is a way to do it with a script that takes the list of djID from the
link table and then makes a new select.. but I'm sure there is a way to do
it at once..
I looked in the MySQL book from paul dubois and somewhere it states how to
change subselects into selects for mysql, but I can't acheive my goal.
Any help appreciated
Etienne
----- Original Message -----
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Technodium.net'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 8:56 AM
Subject: RE: Beginner help with selecting
> Ok
> So you give the event an ID and the DJ and Id
>
> Select dj.djid
> from dj, event
> where event.eventid = 'x';
>
> I think this should work?
> Long weekend so if this is not right it should be close!
>
> Simon
>
> -----Original Message-----
> From: Technodium.net [mailto:[EMAIL PROTECTED]]
> Sent: 16 July 2001 13:41
> To: [EMAIL PROTECTED]
> Subject: Beginner help with selecting
>
>
> Hello there, I would need some help with a select statement for my
> databases.
>
> I've done all the design of the database and I think it's all good, but I
> can't make a select as I want to do it.
> There is the problem:
> I have one table for the list of events and one for the list of djs for
this
> event.
> I have also one linking table with the list of events keys with their
> according djs
>
> I would like to do a select so that for one event it gives me all the
djs..
> But I'm not able to do it.
>
> And after that I'd like to dothe same to be able to get the djs, the
> outlets, etc in less queries than getting the djs ID from the linking
table
> and then doing a new query in the dj table to get the info
>
> If you'd like more info please don't hesitate..
>
> This bug is stopping my progress in the DB design and I can't get help
> anywhere for this
>
> Etienne
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
