Dear all,
I have 2 table viz. A and B
A
id name regcode
1 NY 5
2 Bone 8
3 new delhi 91
4 Masco 7
5 London 8
B
id code name
1 5 US
2 91 India
3 8 west
4 7 North
I want the following out put
Sl No A.name A.id A.regcode
B.Name
1 Bone 2 8
West
2 London 5 8
West
3 New Delhi 3 91
India
4 Masco 4 7
North
5 NY 1 5
US
Here in B.name id correcponding name of B.code used in A.regcode
Can any body assist me in writing sql for MySql server
Thank you with regards,
Mukes Kumar
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
