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
