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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 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
