fetching record from multipul tables
View Single Post
07-25-2011, 01:44 PM
Join Date: Nov 2009
Location: nr Stratford-Upon-Avon
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..
select en.*, nt.*, mt.*, nl.*
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 ?
Sex, Drugs & Linux Rules
View Public Profile
Send a private message to maeltar
Find More Posts by maeltar