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

Extracting URL pointer within XML tag
Hi.

I'm trying to extract text between two quotation marks in XML. For example, I want to ex

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones

TinyMCE / Ajax Postback Problem
Hiya all,

I have a page which loads the TinyMCE editor. On the postback I obviously want to f

Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.

We made a reverse goods movemen

Need help-Error istream header declaration
Hi Everyone ,

I am having issue with istream declaration. I am new to C programming.
can a

Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the

phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:

Code: [Select]$mailer = new PHPMailer();
$mailer-&

VAT
how should I deal with VAT?

if I have a product that costs £5.00 and VAT @ 17.5% (£0.87