the sql query will be
select a.name, a.id, a.regcode, b.name from a,b where
a.regcode=b.code;
if u want serial number also , u have to create a temp
table with an auto_increment field as SRno and insert
the above sql result in that table...
on querieng that table u will get the same result with
the sr no.s
I would like 2 know any other way if it can be done...
~pallav
--- Mukesh Kumar <[EMAIL PROTECTED]> wrote:
---------------------------------
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]
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
Visit your group "php-list" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.
---------------------------------
___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo!
Security Centre. http://uk.security.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/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/
