asked on

Including items from various tables in a query MySQL.

Hi,

I need to generate a MySQL query based on a field from a table. My database contains 2 tables. On each record found by the query I need to include data from the other table. This other data should be linked based on a specific field on the record found by the main query.
Hope I have explained myself.

Regards

Ara-

Your question is kinda vague, but you can do a new SELECT in the WHERE-clause.

E.g.:
SELECT name FROM table1 WHERE id=(SELECT id FROM table2 WHERE field=3)

ASKER CERTIFIED SOLUTION

Cornelia Yoder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

theGhost_k8

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ara-

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jeff_01

Perhaps you could provide a bit more info and some sample data but I think you are trying to do this below ?

select * from tableA, tableB where tableA.ID = tableB.ID

Cornelia Yoder

Don't use JOIN unless you absolutely have to, it's much messier and complicated to understand and debug.

Tomas Helgi Johannsson

Hi!

To speed up the query make sure that you have indexes on both tables
that matches the columns you use in the where clauses of the query . :)

Regards,
Tomas Helgi

lxfdirs

ASKER

Guys:

Thank you all for the suggestions.
I will be checking on them and come back to you with the accepted solution.

Regards

Guy Hengel [angelIII / a3]

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.