Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lowcostlasers
Starting Member
1 Post |
 Posted - 2008-03-22 : 12:17:03
|
| Hi, My first post here, so i hope i'm in the right place.I have a website that has been live for some time now, and my host has just upgraded from sql4, to sql5. Since they did this i get an error in my site that suggests it cannot find a field in a paricular table. I have checked the table, and the field is still present. The error my site returns is:1054 Unknown column 'fg.products_id' in 'on clause'in:[select fg.*, p.products_id, pd.products_name from free_gifts fg, products p LEFT JOIN products_description pd ON (pd.products_id = fg.products_id) WHERE pd.language_id = '1' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC]Is there anything in this query that is non compliant with version 5 of SQL?, and if so, what needs to be changed?Also, what is the "ON" statement, in this query, as it's not one i'm familiar with.ThanksSteve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-22 : 12:27:11
|
| What is sql4 and sql5? Those aren't versions of SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-22 : 16:13:26
|
| If you are talking about MySql, this is wrong place. |
|
|
|
bobross80
Starting Member
11 Posts |
Posted - 2008-03-22 : 20:10:41
|
quote:
Originally posted by rmiao
If you are talking about MySql, this is wrong place.
This site is broadly or generically titled "SQL Team". The title is not denotative of a specific software brand or version. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-22 : 21:13:51
|
| maybe so... but forums are all in one way or the other named sql server something.there's no other RDBMS sections._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
|
|
Query fails using SQL5