>> This is probably tediously basic for all you super whiz
> MySQL people
> but help me out if you can.
>>
>> I have 2 tables in my database (there will be more)
>>
>> table_Applics & table_keywords
>>
>> I want to select columns of information from
> table_applics based on the
> ID results from table_keywords. something like this I
guess,
>>
>> Select ID From Keywords Where markets = 'Financial'
>> This then gives me a list of ID's which I then want to
> take to
> table_applics and get the row of information for each ID
> number in the
> list that exist
>>
>> Select ID,NAME,LNAME,ADDRESS1 from table_applics
>>
>> Whats the best way to achieve this in a single query ?
>>
>> can any one help me with the Logic !!!
>>
>>
>> Here from you soon I hope,
>> Best regards
>> Andy Fletcher
>
> ------------------------------------------------------
> You can try that:
> I do not know if it is what you are looking for:
>
>
> SELECT ----- FROM TABLE1 INNER JOIN TABLE2 USING
> (common_column) GROUP BY ------ ORDER BY ----;
>
> Another way:
>
> SELECT ----- FROM TABLE1 INNER JOIN TABLE2 ON
> table1.field=table2.field (field as common_column) GROUP
> BY ------ ORDER BY ----;
>
> -------------------------------------------------------
>
> I hope that it works.
>
> Marcelo Araujo







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to