> concat('C',c.contact_id) as ref That worked. Thanks the the tip.
Now, lets say I have three tables: contact contact_id int prospect prospect_id int client client_id int If a contact is a prospect, it will have a line in both the contact and prospect table, with the same id value. If a contact is a client, it will have a line in the contact, prospect, and client table, all with the same id value. For example: contact_id 1 contact_id 2 prospect_id 2 contact_id 3 prospect_id 3 client_id 3 I want the ref numbers to be: C1 P2 L3 Is there a way to use a query to do that? Something like: create or replace view view_AllData as select concat('C' or 'P' or 'L',c.contact_id) as reference_number, from contact c left join prospect p on c.contact_id = p.prospect_id left join client l on p.prospect_id = l.client_id Any ideas how to do this? Thanks Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org