> well the easiest way is just to grab both prices and give one > an alias, then you have access to both of them in your code.
Sorted in some fashion. Grabbing the client service info and doing a left join on the employee one so if there's an employee cost it gets returned, otherwise NULL, so I can just do the nice easy printing bit programatically: ID Description Client Employee ---------------------------------------------- 1 Service Description 123.45 NULL 5 Service Description 200.00 250.00 12 Service Description 52.12 NULL 27 Service Description 49.95 69.99 Cheers all. Tim. ------------------------------------------------------- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 ------------------------------------------------------- rawnet ltd Atrium Court Bracknell [EMAIL PROTECTED] Berkshire Tel : +44 (0) 1344 393 040 RG12 1BW, UK http://www.rawnet.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
