TalkPHP - View Single Post

maeltar · 07-25-2011, 01:44 PM

Can you post the exact error message please, as it usually says "near", and you may be looking at the wrong place..

Also, are the datatypes the same, if not use CAST..

Is

Code:

select en.*, nt.*, mt.*, nl.*

Correct ?

If I understand this correctly where you have "en.id" this is not "field.table" but it is a field name alone.

Is this for MySQL ?

07-25-2011, 01:44 PM	#3 (permalink)
maeltar The Acquainted Join Date: Nov 2009 Location: nr Stratford-Upon-Avon Posts: 137 Thanks: 3	Can you post the exact error message please, as it usually says "near", and you may be looking at the wrong place.. Also, are the datatypes the same, if not use CAST.. Is Code: select en., nt., mt., nl. Correct ? If I understand this correctly where you have "en.id" this is not "field.table" but it is a field name alone. Is this for MySQL ? __________________ Thanks... Simon Sex, Drugs & Linux Rules