Professional Web Applications Themes

Query problem... - MySQL

How to make a query within to tables with a linked table ? How to get for instance all the adresses in a mail_group of a determinated "nom" of the table "mail_adresse". Thanks to help me... Martine...

  1. #1

    Default Query problem...

    How to make a query within to tables with a linked table ?

    How to get for instance all the adresses in a mail_group of a
    determinated "nom" of the table "mail_adresse".

    Thanks to help me...

    Martine


    Martine Duval Guest

  2. #2

    Default Re: Query problem...

    Martine Duval wrote:
    > How to make a query within to tables with a linked table ?
    >
    > How to get for instance all the adresses in a mail_group of a
    > determinated "nom" of the table "mail_adresse".
    >
    > Thanks to help me...
    >
    > Martine
    >
    >
    > ------------------------------------------------------------------------
    >
    > -- phpMyAdmin SQL Dump
    > -- version 2.6.1
    > -- [url]http://www.phpmyadmin.net[/url]
    Sorry, Martine, I don't understand your question. What exactly are you trying
    to do?

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: Query problem...

    > Martine Duval wrote:
    >> How to get for instance all the adresses in a mail_group of a
    >> determinated "nom" of the table "mail_adresse".
    Sounds like you need all addresses from a group, in which one specific
    address is a member.

    SELECT a2.*
    FROM mail_addresses AS a
    JOIN mail_ad_gr AS ag ON a.id_user = ag.id_user
    JOIN mail_ad_gr AS ag2 ON ag.id_group = ag2.id_group
    JOIN mail_addresses AS a2 ON a.id_user = ag2.id_user
    WHERE a.nom = ?

    Regards,
    Bill K.
    Bill Karwin Guest

  4. #4

    Default Re: Query problem...

    Not exactly, I need all the mail adresses of one or many groups.

    Thanks for four reply

    Best regards,

    Martine D.

    Bill Karwin a écrit :
    >> Martine Duval wrote:
    >>
    >>> How to get for instance all the adresses in a mail_group of a
    >>> determinated "nom" of the table "mail_adresse".
    >
    >
    > Sounds like you need all addresses from a group, in which one specific
    > address is a member.
    >
    > SELECT a2.*
    > FROM mail_addresses AS a
    > JOIN mail_ad_gr AS ag ON a.id_user = ag.id_user
    > JOIN mail_ad_gr AS ag2 ON ag.id_group = ag2.id_group
    > JOIN mail_addresses AS a2 ON a.id_user = ag2.id_user
    > WHERE a.nom = ?
    >
    > Regards,
    > Bill K.
    Martine Duval Guest

  5. #5

    Default Re: Query problem...

    Martine Duval wrote:
    > Not exactly, I need all the mail adresses of one or many groups.

    It's still not clear. Can you show an example of the data, and the
    desired result?

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. query problem
    By Tony Rogerson in forum Coldfusion Database Access
    Replies: 35
    Last Post: November 2nd, 03:01 PM
  2. Query problem, please help.
    By Raphael Emportu in forum MySQL
    Replies: 2
    Last Post: April 27th, 10:14 AM
  3. Query of Query problem
    By JakeFlynn in forum Macromedia ColdFusion
    Replies: 18
    Last Post: August 11th, 08:15 AM
  4. Problem with query
    By toby007 in forum Coldfusion Database Access
    Replies: 2
    Last Post: June 9th, 10:52 PM
  5. Query on Query and CF casting problem
    By obxlefty in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 18th, 12:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

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 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139