This is a multi-part message in MIME format.

------=_NextPart_000_004C_01C075A8.72A8E240
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys
           I had a similar problem but this is how i managed to solve 
it.  I created a view with a standard number of fields which i need to 
pick from all the disired tables. i.e a view for each table. Picking 
only the fields i need in my final table. Then i created a Union query 
that picks all records from all the views. From here you can either 
produce a report or write to another table.

This is the example of the code

select * from VTable1
UNION ALL select * from VTable2
UNION ALL select * from VTable3
UNION ALL select * from VTable4
UNION ALL select * from VTable5
UNION ALL select * from VTable6
ORDER BY  [no];

Thats it give it a shot and let us know what happened

Sammy Msafiri


---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com