| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 56538 | 2005-04-08 02:48:00 | Unique Recordset Identifiers with MS SQL | CreightonBrown (5692) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 342664 | 2005-04-08 02:48:00 | I want to have multiple fields from multiple tables have unique names or a way to uniquely identify them when using table1.*, table2.* Any ideas? e.g. Order gets the second order and not the first I realise order has to be escaped in [order] when doing the sql but not for the RS Example data 1213FlatType101Flat Information11912Available: Whole Flat01213FlatType101Flat Information12012Available: Partial, Shared Resources01213FlatType101Flat Information12112Available: Partial, Individual Resources01213FlatType101Flat Information12212Wanted, Whole Flat01213FlatType101Flat Information12312Wanted, Partial, Shared Resources01213FlatType101Flat Information12412Wanted, Partial, Individual Resources0 It will be for www.rentaflat.co.nz (http://www.rentaflat.co.nz) |
CreightonBrown (5692) | ||
| 342665 | 2005-04-08 02:49:00 | Looks like it took out the table which showed in the preview | CreightonBrown (5692) | ||
| 1 | |||||