Hello, can you send the datastruktur, so it is difficult to answer your
question.
You don't need, if the other answers were ok.
Regards Gerlinde Fischer
At 08:40 16.07.01 -0400, Technodium.net wrote:
>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
BLITZ Internet Service GmbH
Kronacher Strasse 41
D-96052 Bamberg, Germany
Tel. +49/951/9685160, Fax +49/951/9685164
http://www.blitz.net
---------------------------------------------------------------------
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