Advertisement
junfan59

sql query between 3 tables and an input value

Aug 21st, 2015
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. SELECT `identifier`
  2. FROM `sys_file`
  3. JOIN `sys_file_reference`
  4. ON sys_file.uid = sys_file_reference.uid_local
  5. JOIN `tx_news_domain_model_news`
  6. ON sys_file_reference.uid_foreign = tx_news_domain_model_news.uid
  7. WHERE sys_file_reference.pid = "13"
  8. AND tx_news_domain_model_news.title = "the GPvar of my input title form..."
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement