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

Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet

Your Answer:

Login to answer
73 Like 24 Dislike
Previous forums Next forums
Other forums

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

PHP & Java
Hello,

can PHP code be used inside java code?

Code: [Select]<SCRIPT LANGUAGE=&q

New Login Script
Hi all, i attempted to create a whole new login script witch isnt working for some reason i dont kno

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Format timestamp from mysql
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:

IDOC error
Hi, When i send IDOC from ECC system to MII there is no problem ECC side, i says message sent succe

Error In Syntax
I got this error:

Code: Parse error: syntax error, unexpected '>' in /home/bucket/publ

php/mysql auto logout after 2 hour and reset password
Hi all,

This I hope will make sense. I've the following code which when a user logins in, cr

How to validate from 2 possible answers
Hi

I hope somebody can help me with what will probably be really simple, I'm pulling my hair

Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.

I have maxminds geoip lite installed and i

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash