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 > > > > > > > > > > > ------------------------ 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/
