Hi Steve, I propose you provide the create statements to build the tables and some insert statements for example data.
Sincerely, Dirk Zoettl P.S: Getting help is more probable, if you help the helper ! __________________________________________________________________ Steve Brett wrote: > > i have a table of people and a table of names( forenames and surnames). > > there is a link table with person_id,fname_id and position in it and > surnames are kept in a seperate table. > > what i need to do is pull out a specific person with the name in the format > > <fname1> <fname2> <fname3> <surname> > > i can't work out how to do it in a single sql statement .... > > any ideas ? > > Steve Brett > SID > EMIS Ltd. > > "Privileged and /or Confidential information may be contained in this > message. If you are not the original addressee indicated in this message (or > responsible for delivery of the message to such person), you may not copy or > deliver this message to anyone. In such case, please delete this message, > and notify us immediately. Opinions, conclusions and other information > expressed in this message are not given or endorsed by my firm or employer > unless otherwise indicated by an authorised representative independently of > this message." > > Egton Medical Information Systems Limited. Registered in England. No > 2117205. > Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth, > Leeds, LS18 4RF > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
