Trevor
|
| Posted: 09/17/2002, 8:12 PM |
|
I have the following sql statement which works perfectly in mySQL but when used in CodeCharge it will not return the country name????????? Any ideas would be very helpful.
SELECT clients.client_id, clients.b_city, clients.b_zip, countries.name, orders.order_id, orders.option1, hosting_plans.name
FROM ((clients INNER JOIN orders ON clients.client_id = orders.client_id) INNER JOIN hosting_plans ON orders.product1 = hosting_plans.hosting_plan_id) INNER JOIN countries ON clients.b_country = countries.country_id
WHERE (((clients.client_id)=1) AND ((orders.order_id)=8));
|
|
|
 |
Trevor
|
| Posted: 09/17/2002, 8:21 PM |
|
Please forget this post!!!! I had two fields in two joined tables with the same field name. CodeCharge obviously does not handle this.
Thanks anyway!
|
|
|
|
|
