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

No comments posted yet

Your Answer:

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

Problem with the Update command used with a sqldataadapter
I'm connected to a database on an SQL Server and I'm using a sqldataadapter, sqlconnection, sqldatas

user data not transferring to new page
I'm a PHP learner. After an index.php page, the user goes to a login.php page. Both pages seem to

Internal class functions don't seem to get executed.
Hi. Can someone please put me out of my misery on this. I don't write much PHP and this has me baffl

What exactly is net neatrality?
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

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