<br><br><div><span class="gmail_quote">2006/11/9, Hamish <<a href="mailto:hamish_nospam@yahoo.com">hamish_nospam@yahoo.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Nicolas Devaux wrote:<br>> I know what is a table join, and as I say, I made the join (using Cat<br>> as common fields of both tables to join), but what I want is to see<br>> result within Grass on the attribute table of my vector layer.
</blockquote><div><br>Ok but you are talking about a query. You are only issue a SQL instruction, so your results are temporarily and grass does not know nothing about it. As Jarek said, you must create a new table and then put your query's results in it using a INSERT INTO new_table_name SELECT * FROM tbl_a JOIN tbl_b USING(key_name) or JOIN ON .. ...
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">> house's owners. Now, I want to be able to use this information within<br>
> Grass, and when I look at the attribute table, I don't have owner<br>> names, I have only cat number as in the attributre table before the<br>> join operation made in MySql. </blockquote><div><br>Right... as long the table doesn't exist.
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I think that I miss something... I<br>> would like to transform the join operation results as permanent
<br>> information within my points cover attribute table.... Perhaps I<br>> should make the join table operation directly in Grass instead of<br>> doing it in MySql ? If is is the solution, how can I do, what is the
<br>> command ?</blockquote><div><br>The solution would be to work with views. <br>Grass sees views, connects to views and this is wonderful, but... more it would be if it could handle them correctly. I tried to link to views but quering on the attributes doesn't work correctly.
<br></div><br></div><br>