Connecting 2 tables in 1 database

[dw8081]

i have 2 database & need some code to solve this problem.

table 1 (food_place) :
fp_id | fp_name
1 | McD
2 | Burger King
3 | Pizza Hut

--------------------------------------------
table 2 (promo) :
p_id | p_name | p_pid
1 | Disc.10% | 1
2 | Free f. fries | 1
3 | buy 1 get 1 | 3

--------------------------------------------
fp_id & p_id is auto increment
I need code that can show result like this :

Mc D
Pizza Hut

--------------------------------

thx u for anyone to help me !

[me655321]

What about Burger King?? Why is that not in the result?

[dw8081]

Burger king not in display result becoz at this record burger king not have a promo program (see table promo - p_pid).

[chankya]

SELECT distinct (f.fp_name) FROM food_place f,promo p where f.fp_id=p.p_pid;

Hope this will work for you. :)

[dw8081]

Thx u chankya,

this is what i am looking for :)