multiple fields from multiple tables have unique names

[DigitalBuilder]

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

http://www.rentaflat.co.nz

 

[JamesLean]

It is not best practice to use SELECT * - you should explicitly state which columns you want. That way you can give each one an alias and solve your problem:

SELECT t1.c1 AS t1c1,
  t1.c2 AS t1c2,
  t2.c1 AS t2c1,
  t2.c2 AS t2c2
FROM t1 JOIN t2 ON ...

--James