Don't need an SP for this.. SELECT table_a.table_a_id, table_b.table_b_id INTO table_c >From table_a, table_b
-----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: 07 July 2006 07:40 To: SQL Subject: How would I go about doing this in a SP? My SQL is not at the level of expertise, I understand that I need a way to create a table based of two other tables. Table A has records with a RecordId, and Table B also has this with a relationship of many to one to Table A. Now I need to create a Table C that will sit in between these 2 that contains the RecordID of Table A and all relationships of RecordID's from table B that contain the recorded from Table A. Now I have the Table C created, all I need to do is create a query that will populate this table with the data from Table A & Table B. Hoping someone can help me out here. So it ends up like this Table_A_Id | Table_B_Id ------------------------ 100 | 200 100 | 201 100 | 202 100 | 203 101 | 204 102 | 205 103 | 206 103 | 207 Appreciate any help anyone can give me on this:-) Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:6/messageid:2499 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6; //Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
