I have not tried, but i think this is what he meant:
FROM
tn t
INNER JOIN bill_info b ON (b.id_b = t.id_t)
LEFT JOIN shipp_info sh ON (b.bill_id=sh.bill_id)
HTH,
On 1/16/07, Chris White <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> FROM ".$tn.", bill_info as b
> LEFT JOIN sh
Ran
On 1/11/07, Peter Bradley <[EMAIL PROTECTED]> wrote:
Ysgrifennodd Tomás Abad Fernández:
> I dont know why thease don't work at MySql 3.21 , anyone can help me to
make
> this compatible with mysql3?
>
> $query = "SELECT * FROM facturas WHERE pedido IN (SELECT orders_id
Hi all,
If my post is irrelevant to the list, please let me know.
I have conditions (REGEXP 'STRING' or ='STRING') as JOIN condition or as
WHERE clause condition, i wonder for a 10 table LEFT/INNER JOIN query, which
approach is better and why.
Thanks,
ran
i.e.
ead mysql.user. Now dbuser knows more than he needs, which
is a security concern for me.
So is there a way to both be secure and still allow a user to connect?
Thanks
-
Ran Pang
SE 99
e-mail: [EMAIL PROTECTED]
http://www.cas.mcmaster.ca/~pangr
tel: (905)529-5619
---
an answer.
P.S I used earlier version of mysql ( 1.6 i think ) for linux and These problems
NEVER occur.
there for i am sure that my code is correct ( i tried the same code on this DB)
Best Regards
Ran Salomon
E-mail: [EMAIL PROTECTED]
---
