On Fri, 2005-07-29 at 09:41 +0530, Gnanavel S wrote: > > Joined: > > test=> explain analyze > test-> SELECT cli_name,order.* > test-> FROM order > test-> JOIN client ON (ord_client = cli_code) > test-> WHERE ord_batch='343B' AND > ord_id='12-645'; > > where is the cli_code condition in the above query?
I don't understand the question. ord_client is the client code, and cli_code is the client code, for their respective tables. batch/id is unique, so there is only one record from order, and only one client to associate. Clearer? -- Karim Nassar <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly