Hi Mukesh, Just tried it in access and got exactly the result you asked for. Would you like me to send you the test database I used? Ian
On 19/10/05, 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<http://groups.yahoo.com/gads?t=ms&k=Php+mysql&w1=Php+mysql&w2=Job+postings&c=2&s=33&.sig=FLGkJVBUdDMln4PBO26sng> > Job > postings<http://groups.yahoo.com/gads?t=ms&k=Job+postings&w1=Php+mysql&w2=Job+postings&c=2&s=33&.sig=cV3rp9pSpCxahJy7imon_w> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "php-list<http://groups.yahoo.com/group/php-list>" > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > [Non-text portions of this message have been removed] ------------------------ 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/
