I have following doubts on join condition
Table 1 primary key (id,sub)
Name id sub marks
xxx 61 maths 45
xxx 61 science 50
another table primary key ( id,language)
id language write
61 english yes
61 Hindi no
Output:
Xxx 61 maths 45 english yes
Xxx 61 maths 45 Hindi no
Xxx 61 science 50 english yes
Xxx 61 science 50 hindi no
how to join these tables to get
every information in 2 rows will it possible
xxx 61 maths 45 English yes
xxx 61 science 50 hindi no
please suggest me to right path
thanking u
please mail to me:nallisalmon@.yahoo.co.in
I don′t see the logic which one has to be excluded from the output results ? Is it just randomly or is there a deeper logic implemented ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment