Pallav's solution should produce the correct output, provided all a.regcode exist in b.code.
If you need proper case capitalization, (New Delhi rather than new delhi), you will need to manipulate capitalization of individual result fields in your script. Mike On 10/19/2005, "Mukesh Kumar" <[EMAIL PROTECTED]> wrote: > > > > >Thank Ian, >But still don't get the result >forget Sl. no it can be created in programming script > > >but opt put is not right >Thank you, >Mukesh Kumar > >----- Original Message ----- >From: "Ian Bambury" <[EMAIL PROTECTED]> >To: <[email protected]> >Sent: Wednesday, October 19, 2005 3:39 PM >Subject: Re: [php-list] select sql needed > > >> Hi, >> You need something along the lines of: "SELECT * FROM a LEFT JOIN b ON >> a.regcode = b.code" >> but where you get "SI No" from is anyone's guess >> Ian >> >> >> [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 >> >> >> >> >> >> >> >> >> >> >> > > > > > > > > > >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 > > > > > > > > > > > SPONSORED LINKS > > > > > Php mysql > > > Job postings > > > > > > > > > > > > > > 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. > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
