CRUE - two tables inner join

[petrwabi]

Hello all,
I´m absolutely newbie in javascript. I use Sigma Grid as listed in Tutorial 3 - CRUD. It works fine.
But I need to use inner join in my query.
Is it possible to use similar code?
Many thanks Petr

There are 3 tables - owners, dogs and ownerdog(cols id_dog and id_owner)
<?php $sql1=mysql_query("select id_owner from owners",$GLOBALS["link"]);     while ($row1=MySQL_Fetch_Array($sql1)) {       $people=$row1["id_owner"]; } $sql2=mysql_query("select dogname from dogs inner join ownerdog on dog.id_dog = ownerdog.dog where ownerdog.owner=".$people,$GLOBALS["link"]);                   while ($row2=MySQL_Fetch_Array($sql2)){ echo"<table><tr><td>($row2["dogname"]) }       ?> ..... etc.

[steven]

yes, you can do it that. Is there any problem?

[petrwabi]

Hi, I tried it but without success. The data cannot be loaded. Any suggestion?
Many thanks Petr

[petrwabi]

If I use query from one table it works without problem.