[AccessD] SQL Question

Martin Reid mwp.reid at qub.ac.uk
Tue Jun 24 10:32:32 CDT 2003


Have two tables 

Table A Contains staff data, Name etc
Table B contains contact data

Results of join as expected

Staff Member A  Telephone Number 1
Staff Member A Telephone Number 2
Staff Member A Telephone Number 3

And so on

What I need to do is to flatten this out and create a single table

Staff Member A     Phone Number 1     Phone Number 2     Phone Number 3 etc
Staff Member B      Phone Number 1    Phone Number 2

We dont knwo how many numbers will exist for each member of staff but the Max will be 5 and I must end up with a single table containing the data.

Need this to work in Access and SQL Server 2000

Martin





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030624/02f918d6/attachment-0001.html>


More information about the AccessD mailing list