Help needed to query two tables at once

[kingnutter]

Hi everyone,

 

I have given this a good Googling but not found the answer.

 

I am trying to query two tables to produce one result, hopefully in one seamless query. Below is a hybrid Plain English / PHP version of exactly what I am trying to achieve.

 

{
$data = mysql_query("SELECT moj_id, track_artist, track_title FROM tracks WHERE upper(track_artist) LIKE '%$find%' OR upper(track_title) LIKE '%$find%' THEN SELECT moj_title FROM mojocd WHERE moj_id IS THE SAME AS THE ONE IN THE FIRST PART OF THIS QUERY");
}

 

Any pointers?

[Psycho]

Learn how to use JOINS to really utilize a database

 

SELECT t.moj_id, t.track_artist, t.track_title, m.moj_title

FROM tracks t
JOIN mojocd m ON t.moj_id = m.moj_id

WHERE upper(t.track_artist) LIKE '%$find%'
   OR upper(t.track_title) LIKE '%$find%'

[kingnutter]

Ah. Very interesting.

 

I shall do so and report back if I get jumbled.

 

Thanks for the speedy reply.