var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm having 3 tables. mm,sm, and md.
In mm in i've 3 fields mid,mno,mname.. in sm i've 3 fields like sid,sno,sname and in md i've mdid,mdno,mdcapacity,mdyearofmfg
mid mno mname
1 M0001 xxxx
2 M0003 yyyyy
sid sno sname
1 S0001 Sample
2 S0002 Sample1
mdid mdno mdcapacity mdyearofmfg
1 C0001 2HP 2007
but what is my doubt is.. I want one select query which should have answer like this
mno mname sno sname mdid mdcapacity mdyearofmfg
M0001 xxxx S0001 Sample 1 2HP 2007
How to get this.. Help me in this.
Originally Posted by rk4088
How to get this..
the tables are not related
you will have to redesign them
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors