help multiple join query

jansky

to all guru

im redesigning quey and i got sql error result

here is my query

SELECT links.idLink as idlink , links.company as company,links.linkStart as linkStart, links.linkstatus as linkstatus,
upper(concat(customer.name,' ',customer.lastName)) as fullname,
customer.email as email,customer.idCust as idCust,
cartHead.idOrder,cartHead.paymentType
FROM links
left join customer on (customer.idCust= links.idCust)
left join cartHead on (cartHead.idCust=customer.idCust)
left join (select * from cartrows where sku='FFN-0001') as oh on cartHead.idOrder=oh.idOrder
WHERE links.linkType='FFN-0001'

and the error display is

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from cartrows where sku = 'FFN-0001' ) as oh on cartHe

since the original query does not have any join statement and thus a new requirement is to sort

"sorry for my bad english"

laserlight

What is your relevant database schema, and what exactly are you trying to retrieve?

jansky

oopsss.. the query work well in the server but not in my local workstation

any idea why the query is not working in my local?

laserlight

any idea why the query is not working in my local?

I could speculate things like:
a) You used the wrong login credentials
b) You forgot to start the local database server
c) You forgot to create the tables
d) You are using a version of the database management system considerably different from the one installed on your server
e) You forgot to install the database management system software
f) Your application firewall is blocking the local database server
g) Your computer is infected with malware that causes your database management system software to break

So yeah, this kind of problem is hard to diagnose without more information.

EDIT:
Thankfully, we can rule out all except a variant of c (you created the tables with an old and thus wrong schema), d and g, since it seems that you are able to get to the point where MySQL reports an error.

jansky

okay the goal is to make one query in a multiple table

currently the original query looks like this
first query

$sql=mysql_query(" SELECT FROM links WHERE linkType='FFN-0002'"); // first query
while ($r=mysql_fetch_object($sql))
{
$sql2=mysql_query("select from customer where idcusto=$r->idCust"); // second
while ($r2=mysql_fetch_object($sql2))
{
$sql3=SELECT a.idOrder,a.paymentType, b.terms FROM cartHead AS a, cartrows AS b WHERE a.idCust='".$r->idCust."' AND a.idOrder = b.idOrder AND b.sku = 'FFN-0002'; // third
}
}

this works okay, but here come another problem
we want to sort the fields

so i come up with the new sql statement as mentioned above

any alternative sql for this one?
thanks