how to select items on 2 tables

[pixeltrace]

hi,

 

i need help, i need to display results from 2 different tables

but having the same fields.

my problem is , i dont know how my select query will be.

 

its something like this

$uSql = "SELECT * FROM table1 AND table2";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}else{
while($uRow = mysql_fetch_array($uResult)){

 

 

hope you could help me with this.

 

thanks!

[MadTechie]

somthing like this

$uSql = "SELECT * FROM table1, table2 where table1.ID = 10";

[pixeltrace]

hi,

 

its still not working and i am getting a no data found

 

$uSql = "SELECT * FROM jos_findit, jos_findit2";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}else{
while($uRow = mysql_fetch_array($uResult)){

 

this is the query that i used

 

hope you could help me with this.

 

thanks!

[MadTechie]

try this

$uSql = "SELECT * FROM jos_findit, jos_findit2";
$uResult = mysql_query($uSql, $connection)or die(mysql_error());
if(!$uResult){
echo 'no data found';
}else{
while($uRow = mysql_fetch_array($uResult)){