sql - Select result from multi tables with joins -


i have query. want select

surgery type
surgery details
modality id

am on right path atleast?

the link table middle of everything

addmission 1tom on link
surgery mto1 on link
modality mto1 on link

my problem add in modality.id result.
skip modality, , query works 100%

updated (dropped multi alias) 

select surg.srg_details, surg.type, modd.id surgery surg join link lnk on lnk.lnk_id = surg.srg_lnkid join modality modd on modd.mod_lnkid = lnk.lnk_id join admission adm on adm.adm_id = lnk.lnk_admid  adm.adm_id = 192100042

try use in case:

select surg.srg_details, surg.type, mod.id surgery surg, modality mod join link lnk on lnk.lnk_id = surg.srg_lnkid join admission adm on adm.adm_id = lnk.lnk_admid  adm.adm_id = 192100042 , surg.srg_lnkid = mod.mod_lnkid

Comments

Post a Comment

Popular posts from this blog

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more