> concat('C',c.contact_id) as ref
That worked. Thanks the the tip.
Now, lets say I have three tables:
If a contact is a prospect, it will have a line in
both the contact and prospect table, with the same
If a contact is a client, it will have a line in
the contact, prospect, and client table, all with
the same id value.
I want the ref numbers to be:
Is there a way to use a query to do that?
create or replace view
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?
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