User Profile

kelvinejimogu replied to #1248 - Every derived table must have its own alias ,

Oct 8 '12, 12:05 PM

Thanks guys it now working as it should be here is the full SQL

Code:

SELECT `Posts`.`Post_id` AS `posts_id`, `Posts`.`title` AS `title`, LEFT(`Posts`.`body`, 512) AS                             `preview`, `comments`.`total_comments` AS `total_comments`, `category`.`Cat_id` AS `category_id`, `body`,`category`.`Cat_name`, DATE_FORMAT(`comments`.`last_comments`, '%d/%m/%Y %H:%i:%s') AS `last_comments`
							FROM `Posts`

...

See more | Go to post

Leave a comment:

kelvinejimogu started a topic #1248 - Every derived table must have its own alias ,

in MySQL

Oct 4 '12, 05:50 PM
#1248 - Every derived table must have its own alias ,
I'm getting error #1248 - Every derived table must have its own alias ,
below is the full msql statement please Help Im newbie many thanks.

Code:

SELECT `Posts`.`Post_id` AS `posts_id`, `Posts`.`title` AS `title`, LEFT(`Posts`.`body`, 512) AS `preview`, `comments`.`total_comments` AS `total_comments`, `category`.`Cat_id` AS `category_id`, `body`,`category`.`Cat_name`, DATE_FORMAT(`comments`.`last_comments`,

...
See more | Go to post

Last edited by Rabbit; Oct 4 '12, 06:49 PM. Reason: Please use code tags when posting code.

No activity results to display

Profile Sidebar

Leave a comment:

#1248 - Every derived table must have its own alias ,