Don't use USING in queries. I don't believe it is part of the official SQL standard (although I'm not certain of that). Drupal convention either way is to use a fully qualified INNER JOIN, on which you can specify the table and field explicitly so there is no ambiguity.
On Wednesday 23 July 2008 9:32:01 pm bharani kumar wrote:
SELECT r.nid, r.vid, r.uid, r.title, r.body, r.teaser, t.tid, t.name, v.vid, v.name, v.description FROM node_revisions AS r INNER JOIN term_node USING ( nid ) INNER JOIN term_data AS t USING ( tid ) INNER JOIN vocabulary AS v USING ( vid ) LIMIT 0 , 30
*MySQL said: *[image: Documentation]http://dev.mysql.com/doc/refman/5.0/en/error-returns.html #1052 - Column 'vid' in from clause is ambiguous
On Wed, Jul 23, 2008 at 11:28 PM, Chris Johnson cxjohnson@gmail.com wrote:
Note that in the vocabulary table and the term_data table, "vid" stands for "vocabulary id". In the node_revision table, "vid" stands for "version id" (unfortunately).
The following SQL should display all of the data from the tables described (untested):
SELECT r.nid, r.vid, r.uid, r.title, r.body, r.teaser, t.tid, t.name, v.vid, v.name, v.description FROM node_revision AS r INNER JOIN term_node USING(nid) INNER JOIN term_data AS t USING(tid) INNER JOIN vocabulary AS v USING(vid);