mysql select query problem

Posted on 16th Feb 2014 07:03 pm by admin

how can i select multiple fields from multiple table in one query like

i have table name t1 and t2

t1 fields are f_id,f_name,f_des

t2 fields are f_id,ft_name,ft_des

i need query which select f_id from both tables and f_name from table t1 where table t2 f_des=1

please help me

Your Answer:

Login to answer

Other forums

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses