YadaTest: Difference between revisions

No edit summary
No edit summary
Line 9: Line 9:
{{#get_db_data:
{{#get_db_data:
  db= vanisearch
  db= vanisearch
  |from= book, prop
  |from= book innner join prop on= book_id=prop_id
|join on= book_id=prop_id
  |data= bid=book_id,pid=prop_id,name=book_name,desc=prop_desc
  |data= bid=book_id,pid=prop_id,name=book_name,desc=prop_desc
}}
}}

Revision as of 13:30, 13 February 2023

Krsna says 'Me'
Krsna says 'My'
Krsna says 'Mine'

The query SELECT book_id,prop_id,book_name,prop_desc FROM book innner join prop on `book_id=prop_id` is invalid (Error 1054: Unknown column 'book_id=prop_id' in 'on clause' Function: EDConnectorRdbms::fetch Query: SELECT book_id,prop_id,book_name,prop_desc FROM book innner join prop on `book_id=prop_id` ).

Id Desc Text