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. You can then choose which one to use. Or you can bung and if statement in your query to select the approprite price.
-----Original Message----- From: Tim Blair [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 15:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] More SQL Q's... > so u have two sets of prices. one in the service table and > one in the employee table, is that correct. And if a service > is listed under both the employee and the customer, then you > want to us ethe price listed in the employee table and not in > the service table. Damn close... ;o) The client cost is stored in the client table, the employee cost is stored in the employee table. No cost is stored in the service table (just the description and whether it's active or not). If there is a cost in the employee table for a particular table then that should override the cost in the client table. I've just got it done simply using two queries, first grabbing the employee costs and doing another query for the client services, using a WHERE clause like "serviceid NOT IT (#valuelist(employee.serviceid)#)". But now I'm just trying to be clever and do it in one query. :oD 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] -- ** 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]
