Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how we access the table data which are linking other table ?

 
Alvin chew
Ranch Hand
Posts: 834
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, good day , if i have say 3 table ,

table_general :


table_workflow:


table_person_incharge:


hi, from these 3 tables, say if i want to get specify prs_name's data from starting of table_workflow, then table_workflow 's prs_name , and finally table_person_incharge, how to we use select statement to get data ? and also update statement for the database ?

thank you very much for helping
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For selection use equi-join. May be somebody will write the whole query for you.

Update can not be done on more than one table using one statement. To update more then one table you need trigger or procedure kind of things.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic