<div dir="ltr"><p>
<span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SELECT</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">nid</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">vid</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">uid</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">title</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">body</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">teaser</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">t</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">tid</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">t</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">name</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">v</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">vid</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">v</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">name</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">v</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">description</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_alpha syntax_alpha_identifier">node_revisions</span> <span class="syntax_alpha syntax_alpha_reservedWord">AS</span> <span class="syntax_alpha syntax_alpha_identifier">r</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">INNER</span> <span class="syntax_alpha syntax_alpha_reservedWord">JOIN</span> <span class="syntax_alpha syntax_alpha_identifier">term_node</span><br><span class="syntax_alpha syntax_alpha_reservedWord">USING</span> <span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_alpha syntax_alpha_identifier">nid</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <br>
<span class="syntax_alpha syntax_alpha_reservedWord">INNER</span> <span class="syntax_alpha syntax_alpha_reservedWord">JOIN</span> <span class="syntax_alpha syntax_alpha_identifier">term_data</span> <span class="syntax_alpha syntax_alpha_reservedWord">AS</span> <span class="syntax_alpha syntax_alpha_identifier">t</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">USING</span> <span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_alpha syntax_alpha_identifier">tid</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <br>
<span class="syntax_alpha syntax_alpha_reservedWord">INNER</span> <span class="syntax_alpha syntax_alpha_reservedWord">JOIN</span> <span class="syntax_alpha syntax_alpha_identifier">vocabulary</span> <span class="syntax_alpha syntax_alpha_reservedWord">AS</span> <span class="syntax_alpha syntax_alpha_identifier">v</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">USING</span> <span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_alpha syntax_alpha_identifier">vid</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_white syntax_white_newline"></span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">LIMIT</span> <span class="syntax_digit syntax_digit_integer">0</span> <span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_digit syntax_digit_integer">30</span></span>
</p>
<p>
<strong>MySQL said: </strong><a href="http://dev.mysql.com/doc/refman/5.0/en/error-returns.html" target="mysql_doc"><img class="icon" src="http://localhost/phpmyadmin/themes/xampp/img/b_help.png" alt="Documentation" title="Documentation" height="11" width="11"></a>
</p>
<code style="color: rgb(204, 0, 0);">
#1052 - Column 'vid' in from clause is ambiguous
<br><br><br></code><br><div class="gmail_quote">On Wed, Jul 23, 2008 at 11:28 PM, Chris Johnson <<a href="mailto:cxjohnson@gmail.com">cxjohnson@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Note that in the vocabulary table and the term_data table, "vid"<br>
stands for "vocabulary id". In the node_revision table, "vid" stands<br>
for "version id" (unfortunately).<br>
<br>
The following SQL should display all of the data from the tables<br>
described (untested):<br>
<br>
SELECT r.nid, r.vid, r.uid, r.title, r.body, r.teaser, t.tid, <a href="http://t.name" target="_blank">t.name</a>,<br>
v.vid, <a href="http://v.name" target="_blank">v.name</a>, v.description FROM node_revision AS r INNER JOIN<br>
term_node USING(nid) INNER JOIN term_data AS t USING(tid) INNER JOIN<br>
vocabulary AS v USING(vid);<br>
<div><div></div><div class="Wj3C7c"><br>
<br>
<br>
On Wed, Jul 23, 2008 at 11:29 AM, bharani kumar<br>
<<a href="mailto:bharanikumariyerphp@gmail.com">bharanikumariyerphp@gmail.com</a>> wrote:<br>
> vocabulary table<br>
><br>
> [php]<br>
> vid name description<br>
> 2 vegitable this is vegitable<br>
><br>
> [/php]<br>
> node_revision table<br>
> [php]<br>
> nid vid uid title body teaser<br>
> 21 21 1 mouse program test test<br>
> [/php]<br>
><br>
><br>
> term_data table<br>
> [php]<br>
> tid vid name<br>
> 5 2 ladies finger<br>
> 6 2 onion<br>
> 7 2 beetroot<br>
> 8 2 ladies finger2<br>
> 9 2 onion2<br>
> 10 2 beetroot2<br>
> [/php]<br>
><br>
><br>
> term_node table<br>
> [php]<br>
> nid tid<br>
> 18 4<br>
> 21 5<br>
> 21 7<br>
> 21 8<br>
> 19 10<br>
> 20 10<br>
> 21 10<br>
> 19 11<br>
> [/php]<br>
><br>
><br>
> Hi friends<br>
><br>
> the above is my table can any one tell the sql query for that ?????<br>
><br>
> id related all content must display with that query...<br>
><br>
><br>
> any great idea,,,plz i welcome<br>
><br>
><br>
> :D<br>
><br>
><br>
><br>
</div></div>> --<br>
> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><br>
<font color="#888888">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br></div>