hi
how to combine three tables in a single query.please send a sample code
thanks

seeker_id is commin in all the tables

sorry for the wrong query in the last post

"select seekers.firstname,...

hi
i want to join four tables.i used left join.thougn value are there in my db all the datas from
seekers_qualification, seeker_target tables are getting displayed as Null.but there is no Sql error...

thanks.i tried this way

SELECT article.id,article.ar_title,article.owner,article.ar_date,addinfo.pat,login.username
FROM article
LEFT JOIN (
login,addinfo
) ON ( login.id = article.owner
AND...

hi,
i want to select from more than two table using a single mysql query.please tell me a example query/.
thanks in advance

hi
I want to fetch data from four tables using a single query.please tell me how to do that.
thanks in advance

html page
<form method="get" action="sort2.php">
<table>
<tr>
<td>SPid</td><td><input type="text" name="spid"></td>
</tr>
<tr>
<td>From</td><td><input type="text" name="from"></td>...

hi i have a form where the user will enter the data based on the user input i want to retrieve data

ex
1st textbox one get the standard (class of the student)
2nd & 3rd textbox get the range...