Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- showing mysql fields as NULL
October 18, 2004, 12:11 am
rate this thread
query. I tried using left join but couldn't get it to work. Here's my
SELECT * FROM info left join info on id=1
query failed:1066: Not unique table/alias: 'info'
Since left join usually uses two tables, I also tried using an alias,
but I got the same error message.
SELECT * FROM info as alias left join alias on id=1
query failed:1066: Not unique table/alias: 'alias'
What as missing ?